Home | “The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user…” – Microsoft Database Connection Error Message
Print or Email this article

“The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user…” – Microsoft Database Connection Error Message

Target Audience: IT Manager
Article #: 11898

Summary

A user reported an IIS error message when trying to access an Excel file in CODESOFT. “The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write its data.” This article explains the problem and provides a solution to resolve the issue.

Microsoft Database connection error message in CODESOFT 2019

Explanation

The likely reason for this error message is that the Windows database connection driver (Microsoft Access driver) is unable to access data from the destination file. In this case, CODESOFT (as part of TEKLYNX CENTRAL) tried to use the driver to access an Excel source file.

One or two situations may be triggering the error message:

  1. The Excel file is stored under a different Windows user profile and the current user lacks permissions.
  2. Another app in TEKLYNX CENTRAL is currently accessing the same file.

Solution

First, move the the source Excel file to a location that allows access by multiple users. An example folder is C:\Users\Public\Documents.

Next, you should make sure that the file is accessible. To do this, disconnect other users and applications. Or, make the file “read only”.

Visit this article for instructions on making an Excel file “read only” to avoid lockouts: ARTICLE

Additional Comments

Issue found in Windows Server 2016

If you need further assistance, please contact us.

Author

Dave Klement

Was this article helpful?

Related Articles