Access Front End with MySQL Backend?

[kmarusek]

Hi Access World,

I'm new to this forum and pretty new to access and mysql. I'm working a small project for a friends company, they have an old split ms access VBA program developed back in 2002. They have a host computer that houses the dB backend file, while they have copies of the front end to all other machines and employees (about 8).

They have had some issues with load times and I thought I'd help them by migrating and linking their backend database tables to a mysql server instance.

I took a copy of their access program to test on my own personal network where I've set my desktop up as the backend mysql host and my laptop as a frontend user. I've migrated the access tables to the mysql instance on my desktop and linked tables, however when I copy the front end file to my laptop it has trouble finding and connecting to the dB. Have I missed a step? The front end file runs fine on the desktop and the desktop is fully accessible to the laptop. I'm having trouble finding documentation or youtube videos. Hope you all can help, thank you.

 

[GPGeorge]

There is a Linked Table Manager in Access. It is used to manage the linking of tables, such as the situation you are in.
You will find it here :

Use it to link the FE on your laptop to the tables.

 

[jdraw]

Haven't done that for several years, but I'd suggest this MySQL link as a starting point.

 

[arnelgp]

before migrating to mysql, you should try first creating a Persistent Connection to the Backend
and see and test if there is any changes in speed.

linking to mysql/mmsql will not guarantee that it will make the db faster.