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.
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.