Hi All,
I'm trying to update MDB_ADO reader in existing workspace - it's new data delivery with the same structure as the previous one. I'm getting "An error occurred while updating the reader".
I tried also open some random tables in blank workspace, and I was able to do it, but after ran workspace I got "Error running translation" or FME has been closed "automatically".
At first I tried to do it in FME 2022.1.1.0 (64 bit), MS Office is 64-bit as well.
Then I installed the newest version of FME 2022.2.5.0 - at first everything worked fine - I updated mdb reader and I was able to run the whole workspace. When I closed FME and opened it again I wasn't able to update reader or open any other random tables in blank workspace - so same errors like in older FME version.
I tried clean all temp files, I created new temp folder, I tried to repair mdb via "Compact and Repair function in AccessDB. After all of these changes I was able again to work with mdb in FME, but after restart computer it doesn't work again anymore. It's really unstable.
It doesn't work with different mdb files as well.
I can read other formats like xls, csv, xml or postgres db - there are no errors.
Right now have to work with original mdb, there is no option to convert it to different format.
I don't have any other idea what is wrong, should I re-install FME?
Any ideas on this are highly appreciated.
Thanks for your help!