MS Access distribution with MySQL backend.

[The_Vincester]

On my development machine everything works great, but I know that I'm going to run into problems with distribution.

I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.

Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.

Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.

 

[boblarson]

If they don't have the actual DRIVER, then you aren't going to get around that. The driver is necessary to "translate" between databases. The ODBC CONNECTION is another thing. You don't necessarily need to create an ODBC Connection on their machine. If you either connect using a File DSN, or pass all connection string information to your connection within code you can get around using an existing ODBC connection.