Skip to main content
  • EN

I'm getting "Provider error `(-2147467259) Could not use ''; file already in use.'" in the log when trying to read an MS Access mdb. This raises 2 questions:

 

1) it's a reader not writer, so why does it care if the file is in use? I have other applications that read mdb fine if it's already open.

 

2) The final status for the entire script is successful. I would expect the failure be noted at the end. I don't know how long we've been missing this error buried in the middle, and more importantly if we have corrupt data at the end as a result.

 

2021-2-5 14:21:29 | Creating reader for format: Microsoft Access

2021-2-5 14:21:29 | Trying to find a DYNAMIC plugin for reader named `MDB_ADO'

2021-2-5 14:21:29 | FME API version of module 'MDB_ADO' matches current internal version (3.8 20200115)

2021-2-5 14:21:29 | Performing query against MDB_ADO dataset `\\\\server\\infosys\\xxx\\WR\\DB\\xxxResources.mdb'

2021-2-5 14:21:29 | Microsoft Access Reader: Opening `\\\\server\\infosys\\xxx\\WR\\DB\\Water Resources.mdb' for read operation

2021-2-5 14:21:29 | Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Engine Type=5;Data Source=\\\\server\\infosys\\xxx\\WR\\DB\\xxxResources.mdb;User ID=admin;Password=********'. Provider error `(-2147467259) Could not use ''; file already in use.'

2021-2-5 14:21:29 | Failed to open reader

 

 ----

FME Server 2020.2.2

Build 20817 - win64

Hi @mattw1ilkie​,

I wasn't able to find much on the error in our Community but did notice some suggestions from an external website for the error that you're getting: https://docs.microsoft.com/en-us/office/troubleshoot/access/error-opening-database

 

It looks to be related to permissions, can you confirm if you have "Read, Write, and Create permissions for the folder in which the database is located"?

Hi @mattw1ilkie​,

I wasn't able to find much on the error in our Community but did notice some suggestions from an external website for the error that you're getting: https://docs.microsoft.com/en-us/office/troubleshoot/access/error-opening-database

 

It looks to be related to permissions, can you confirm if you have "Read, Write, and Create permissions for the folder in which the database is located"?

Ah yes, the permissions on the folder allow read but forbid create (on purpose). I guess that means the other programs I'm thinking of don't use the Jet engine to open the file, or otherwise work around it.

Reply


Community Stats

30,185
Posts
114,569
Replies
37,847
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.