I have a mysql database backend with an Access front end connected by linked table manager. The database and app are on a server, but need to be accessed by client machines. I set up ODBC on the clients and they connect correctly, but everytime they open the app the MySQL ODBC box comes up and has defaulted to a location of localhost as opposed to the server name.

I was wondering if there was a way to prevent this box from coming up and just automatically set the location to the server name?

Fixed it. I had linked to the ODBC through access on the server "localhost" so the ODBC on the workstation was having issues and needed to be relinked and redirected.