In a master-detail form when I query the master it returns the data, then I query for the detail records and it returns the detail data. When I try to add a detail record the application is also trying to add the master. I only want the new detail record. The master already exist.
Answer Question | January 8, 2010 6:23 PM
Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. [...]
Answer Question | May 22, 2009 5:28 AM
BCP Utility, Collation, Format file, import/export
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables, equipment, etc that are in one table. For [...]
Answer Question | May 22, 2009 8:46 PM
Access Database, Microsoft Access, SQL Database
We are running Q+A 5 and cannot do a successful “Recover Database”. Get “FILE IN USE BY aaa, bbb, aaa, ccc, bbb, bbb, bbb” message. All users were out of Q+A. Also we had the users mentioned in message re-boot their XP PRO workstations. Please Note: UIDs repeat in the in-use message.
Answer Question | May 21, 2009 2:51 PM
Database Recovery, Q+A, Q+A 5
I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.
Answer Question | May 20, 2009 4:25 PM
database synchronization, MySQL, MySQL Synchronization
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked tables [...]
Answer Question | May 19, 2009 6:27 PM
Access 2007, Access Database, Microsoft Access, Microsoft Access Performance
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product [...]
Answer Question | May 20, 2009 12:34 PM
Microsoft Access, VBA
Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.
Answer Question | May 20, 2009 9:23 AM
Collation, Database collation, SQL Server 2000
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn’t have ms-access, then how will i connect to it and run my project?
Answer Question | May 19, 2009 12:54 PM
Access Database, C#, Microsoft Access, Network connectivity
Hi, I’m new in ASP.NET so excuse me if this is a stupid question. I’m trying to connect a page to the database but there may be some problem. Please help me…… This the ASPEX file cod: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; [...]
Answer Question | May 8, 2013 5:41 AM
ASP.NET, C, Database connectivity, Web development
I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query “select top 10 * …”, it executes successfully in the query editor window [...]
Answer Question | July 16, 2009 4:27 AM
Microsoft Access 2003, Microsoft Access 2003 forms, Microsoft Access 2003 subforms
I’m using two server 1.Application server(windows XP Pro SP2) and 2.Database server(windows server 2003). when execute an application that will connect to my machine for database access and next it’ll connect to DB server, at this time it produce “Communication Underlying Transaction has failed”.. then i searched so many forums, that says DTC error. Then [...]
Answer Question | May 29, 2009 7:17 AM
Database connectivity, Microsoft Distributed Transaction Coordinator, MSDTC, MSDTC error, Windows Server 2003
My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but [...]
Answer Question | May 18, 2009 3:07 PM
ASP, Microsoft Access
We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits. However…pulling a microsecond(current timestamp) in an [...]
Answer Question | January 9, 2011 2:43 PM
AS/400, ILE RPG, RPG, Timestamp
I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?
Answer Question | May 19, 2009 2:26 PM
Access 2007, Microsoft Access
Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?
Answer Question | May 15, 2009 8:40 AM
DB2 Physical File, DB2/400, DB2/400 primary files, Flat files, Physical File
Please help me by giving script for uploading and updating member photo in his profile using php and mysql
Answer Question | January 3, 2011 5:21 AM
MySQL, PHP, Web development
Another free chapter download is available on the IT Bookworm Blog. Written by: John Goodson and Robert A. Steward Book: The Data Access Handbook: Achieving optimal database application performance and scalability Overview: “Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the [...]
Answer Question | May 14, 2009 12:26 PM
Data access, Database applications, Database performance, Database scalability, Free Chapters, John Goodson, Prentice Hall, Robert A. Steward
implementing roe level srcurity
Answer Question | July 29, 2009 6:07 AM
Database security, Row Level Security
How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.
Answer Question | May 14, 2009 5:57 AM
Database programming, Database schema