Originally posted by arminc01
I want to connect msaccess 2000 to an online mysql database. I have installed the mysql ODCB drivers.
Normally, the mysql connection is through "localhost".
How do I tell msaccess where to locate the online database in the Import Tables | ODCB connection dialog?
You mean you want to make links of all your Tables on MySql in Access 2000? As you installed the ODBC drivers then go to File/External Data/Link tables then in the drop box [File Type] choose ODBC DB. At that moment another dialog box will allow you to choose your ODBC, then choose your Tables.
I am not sure about the Menu names because I use a german Access version