How to connect to Access Database via Data Sources (ODBC) using a mapped network drive?

Question

I need to make a connection to an Access Database. In order to do that I created a System DSN. I had success making that connection using local files.

However, the database must be at a remote server and I mapped a network drive so I can access the database files. Mapping the drive and using the remote files, an error arises when I try to access the database:

"[Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user. "

If I use the database files in the local machine, the error doesn't appear. But accessing the file from the network drive, the exception is throw. Do you know why it happens?

Thanks....

Answer 1

This will sound odd, but add your AD domain to your Trusted Sites in your internet options.

So if your computer is a member of ad.mycompany.com, use that.

I had something similar happen with two people trying to open up the same MDB on a network drive.

Answer 2

I found the problem.

The application invoking my code is a windows service that is running under the SYSTEM account. This account doesn't have permissions to access files outside the server.

A system administrator will create a special account and I need to use it as the service log on account.