Target Audience: IT Manager
Article #: 11898
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.
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:
- The Excel file is stored under a different Windows user profile and the current user lacks permissions.
- Another app in TEKLYNX CENTRAL is currently accessing the same file.
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
Issue found in Windows Server 2016
If you need further assistance, please contact us.