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
Thanks,
Matt Sellers
---------------------------------------------------------------------
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
