using remote MS Access database which connects to remote SQL server
- by Manjot
Hi,
We have a Microsoft Access database + application (on Server A) which connects to a remote SQL server (Server B) using System DSN ODBC connection (on Server A) to the SQL database server.
The users are open this Access database remotely as it is on a shared location on the server A. They still have to create a local ODBC connection on their computers to connect to Server B.
Is there anyway that they can access the Access database and not have to create a local ODBC connection?
thanks in advance