I have an Excel Module that goes into multiple giant Access databases and deletes rows or changes a field from a specific number to a different number...Excel is feeding those specific numbers from a range in a sheet. I am the only one using these databases and excel files. There are no permission problems. The folder is not read only. Sometimes the module runs flawlessly and sometimes it doesn't. I get random automation errors and I think it's because somewhere along the way one of the Databases is randomly changing to "Read-Only" and I have no idea why. I have even tried compacting the databases after each deletion or update so that the database starts "fresh" each time. And compacting adds so much time to the task and yet it still crashes randomly. Any ideas of why this is happening? I am a relatively new programmer. Thank you very much.
Bookmarks