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
