ACCESS and MySQL (1 Viewer)

[bodylojohn]

Hello everybody,

Who can help me.
I want to access a MySQL database with ms access.
I cant seem to get it.

Please help me.

Thanks in advance,
John

 

[peej228]

Linked Tables

install mysql odbc driver 3.51

setup odbc connection (control panel, adminstrative tools, odbc, system dsn tab) put in mysql server host name, username, password, database

open access
right click on the table section, select link tables, files of type select odbc, select the odbc connection you created.

there is an issue with records locking every once in a while but if you viewing data it works fine.

 

[The_Vincester]

There are also some differences with the tables that you may run into. Are you converting are using an existing database?