If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: msaccess to mysql connection

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?

csmith

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
Good luck