I am new to MySQL, by the way.
What is happening here? First, my setup:
- MySQL 4.0.18 running on Windows XP (server)
- Access 2002 using ODBC DSN 3.51.71 (client)
My tables are InnoDB due to the record-level locking. I am migrating my data from Access to MySQL, and I will continue using the application already designed in Access with MySQL as the back-end. I am taking a single-user database app to a multi-user app.
I have already followed the recommendation of MySQL AB and installed all updated datastore-related software including MDAC 2.8 and Jet 4.0 SP8.
Now, the problem:
There are three tables (of 11) in my database where (all) the data shows as "#Deleted" when on the client-side of my ODBC connection, in this case Access (either in forms or in the table's datasheet view).
PLEASE HELP!
I have created completely new databases and linked my tables, but this does not make a difference. Also, I tried to make the configuration of the tables as simple as possible. Nothing thus far has helped.
Thanks in advance.
What is happening here? First, my setup:
- MySQL 4.0.18 running on Windows XP (server)
- Access 2002 using ODBC DSN 3.51.71 (client)
My tables are InnoDB due to the record-level locking. I am migrating my data from Access to MySQL, and I will continue using the application already designed in Access with MySQL as the back-end. I am taking a single-user database app to a multi-user app.
I have already followed the recommendation of MySQL AB and installed all updated datastore-related software including MDAC 2.8 and Jet 4.0 SP8.
Now, the problem:
There are three tables (of 11) in my database where (all) the data shows as "#Deleted" when on the client-side of my ODBC connection, in this case Access (either in forms or in the table's datasheet view).
PLEASE HELP!
I have created completely new databases and linked my tables, but this does not make a difference. Also, I tried to make the configuration of the tables as simple as possible. Nothing thus far has helped.
Thanks in advance.