G
Guest
This is all new to me, so I'm hoping that someone can help.
I created two Access databases -- frontend and backend. Both files are
stored on the network and there are over 30 end-users using the databases
concurrently. We're having a performance issue being extremely slow, so I've
decided to try out MySQL as the backend database. (I've read quite a few
positive feedback about this.)
I downloaded MySQL to my local station at work, created the tables, and
installed the ODBC driver from mysql.com. When I try to link the tables from
MySQL to the front-end Access database, nothing happens.
From Access (frontend), I go to File >> Get External Data >> Link Tables >>
Files of Type = ODBC databases() >> Machine Data Source tab >> Select MySQL
Databases >> click OK. Then Nothing. I'm not given the option to choose the
tables from MySQL database.
I have a feeling that I need to have a dedicated/shared server for MySQL
database to get this to work. Is my assumption correct? Usually I get
prompted to enter a userid and password at the SQL Server Login window. But
I never got this far.
The reason why I didn't have MySQL installed on a server is because I wanted
to learn MySQL and test it before I have anything installed on a server. Can
someone please tell me what is the proper way to do this? I want to use
MySQL to store the data and link the tables to MSAccess as the frontend.
Thanks,
Nyla
I created two Access databases -- frontend and backend. Both files are
stored on the network and there are over 30 end-users using the databases
concurrently. We're having a performance issue being extremely slow, so I've
decided to try out MySQL as the backend database. (I've read quite a few
positive feedback about this.)
I downloaded MySQL to my local station at work, created the tables, and
installed the ODBC driver from mysql.com. When I try to link the tables from
MySQL to the front-end Access database, nothing happens.
From Access (frontend), I go to File >> Get External Data >> Link Tables >>
Files of Type = ODBC databases() >> Machine Data Source tab >> Select MySQL
Databases >> click OK. Then Nothing. I'm not given the option to choose the
tables from MySQL database.
I have a feeling that I need to have a dedicated/shared server for MySQL
database to get this to work. Is my assumption correct? Usually I get
prompted to enter a userid and password at the SQL Server Login window. But
I never got this far.
The reason why I didn't have MySQL installed on a server is because I wanted
to learn MySQL and test it before I have anything installed on a server. Can
someone please tell me what is the proper way to do this? I want to use
MySQL to store the data and link the tables to MSAccess as the frontend.
Thanks,
Nyla