Gossamer Forum
Home : General : Databases and SQL :

ACCESS to mySQL using ODBC

Quote Reply
ACCESS to mySQL using ODBC
Hello,

I'm partially migrating a database from ACCESS to mysql using ODBC. But when I update or insert a record from the ACCESS front end into the linked mysql table, i get the error message that the record is not updatable or that another user has modified my record.

Anybody has any idea how to resolve this.
Quote Reply
Re: [kirty] ACCESS to mySQL using ODBC In reply to
Fraid not.. You may want to check that the user you are connecting with via odbc has write access to the table.

Cheers,

Alex
--
Gossamer Threads Inc.