MySQL Server Question (1 Viewer)

[Clopez]

Hello, I have a database that I'd like my employees to access from MDTs (Laptops) in the field. I'm guessing I need to run it on a MySQL server. I already have the database split. I also ran compact and repair on the database and saved it as an ACCDE file.

How would I get it to run so that my employees can access it in the field?

Thanks

 

[MadPiet]

Did you repoint the Access database front end to the MySQL backend yet? Does it work?

 

[Clopez]

That's where I'm stuck, I can't figure that part out, or which MySQL program to use, I've tried a few but can't seem to figure it out.

 

[June7]

"In the field" means they are not on the same network as MySQL server. They would have to connect over internet, maybe via VPN.

MS Access is not designed to work over internet.

Have you done any research on remote connection to MySQL?

 

[Clopez]

"In the field" means they are not on the same network as MySQL server. They would have to connect over internet, maybe via VPN.

MS Access is not designed to work over internet.

Have you done any research on remote connection to MySQL?

That is correct, they are not on the same network. I have done research, and now I'm stuck, hence the reason for asking here.

 

[June7]

Would these remote laptops even have reliable internet connection? Have you tested connecting remotely using command line commands? From what I've read, it's quite an involved process to set up MySQL to accept remote connections.

MS Access as frontend might not be best path. Review https://www.devhut.net/ms-access-wans-wireless-networks-and-the-internet/

More about using Access remotely https://answers.microsoft.com/en-us...o-access/21ce2545-e868-4fc2-93d2-c553affd374c

I had a situation where workers in field would not have internet at all. Built an Access db for collection of data. File brought into home office at end of project and data imported to master db.

 

[cheekybuddha]

Your initial explanation in Post #1 gives the impression you are very unclear!

A few questions:

1. Do you have a server on which you can host a MySQL instance?
2. If so, and you have set up the MySQL server, have you migrated your Access tables to MySQL
3. Do you know about ODBC connections and the MyODBC connector? The correct version will need to be installed on each machine trying to connect to the server, and the front-end will need to be coded to use it.

Once you have answered those questions, then there will be more!

 

[Pat Hartman]

Access is a client/server application. It is intended to be used on a LAN to share data. It does work over the internet but it is slower than molasses. The best solution is to use Citrix. This will require you to create a Citrix server on your LAN that your people can connect to or purchase the functionality from a third party. An Azure subscription can create the desktops you need to run Access remotely.