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.