Doug Ledbetter wrote:
>
> I've tried using MS Access 97 to link to MySQL databases on a Linux server
> and limited success.
>
> I've had no trouble making the connection and viewing the data, but
> inserting and changing data has been a problem.
>
> Anybody else using MS Access to connect to a MySQL DB on a Unix server?
>
> Is there a better ODBC Client than Access to use?
>
> thanks,
> -dougl
Hi Doug
All your mysql tables you want to modify with Access must have:
a) a PRIMARY KEY
b) a TIMESTAMP field
Then updating works.
Tschau
Christian
