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

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?



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.

Leave a Reply

Your email address will not be published. Required fields are marked *