Locked Data from Access frontend to MySQL backend

[Francois van Jaarsveld]

Hi there

I ran an Access database with a Access frontend, but with 65000 records the Db is very slow, so converted the backend to MySQL and linked the Access frontend to it through ODBC. I currently run MySQL and the frontend locally on my machine for testing purposes.

the problem is that I cannot update anything from the clientside, when I interogate the database, I can view any information I want, but I am unable to run update or append queries or update information that is directly in a table. If I convert the query from access view to SQL view and then run that query directly on the MySQL DB through query analyzer, it works. I get an error when trying to run an update or append query that reads: Operation must use an updatable query and in the form itself, the text fields are just locked.

I have made sure that i have the correct permissions for the ODBC account (root) and even tried with another account with perms to the database. It can also not be a locking problem, As I am the only user logged on to the Database.

Any Input would be most valued.

Thanks in Advance

Francois