Hi !!!! > -----Original Message----- > From: Matt Sellers [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 26, 2001 7:37 AM > To: [EMAIL PROTECTED] > Subject: MS Access Front end with MySQL Back-end > > > Hi there, > > I am new to MySQL, but not to databases. I have several MS Access > databases (97 and 2000) that I would like to integrate, storing their data > in a MySQL database. I want to keep the Access 97 and 2000 front ends, > because my users are comfortable with them. > > I had "autonumber" fields in Access tables to generate IDs for records. I > emulated that behavior by having "auto_increment" fields in the MySQL DB > when I move the data. I have installed myODBC and set up a connection for > Access. I "Get External Data" from Access, and link to the MySQL table. I > have tried having MyODBC set to "Return matching rows" and not, and to > "Simulate ODBC 1.0" and not. Here's the problem. When I insert a row in a > table (from the table in Datasheet view, or from a form), I leave the ID > field null so mySQL will assign it. When I move off the record, all fields > show "#Deleted". If I exit the table and re-enter, or if I requery the > form, the record is there with the expected ID from mySQL. > > Is there some way I can have Access behave in a more acceptable manner when > dealing with linked MySQL tables with auto_increment fields? > > Versions of software I am using: > MS Access 2000 > MySQL server version: 3.23.38-nt > MySQL ODBC ver 2.50.37.00 > Please check the following link for the work-around solutions when the records in the linked tables are displayed as "#DELETED" http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#MyODBC_c lients
Also, upgrade the driver to 2.50.39, available from http://www.mysql.com/downloads/api-myodbc.html Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
