Hi Guys,
Strange issue that has popped up out of no-where. I am assuming it's an Access 2019 issue.
I have a series of several Append queries that append from one database to identical tables in another 'master' database. Both are local and up until recently this always worked with no issues.
Now when I try to run all the queries at once through a macro, I keep getting the error that the 'master' database is locked or protected. The file name also shows up with the .laccdb locked extension in the error message which is strange. I check the append directory and they are all correct (the normal .accdb file extension).
When I run these queries individually everything works fine, but when executed by a macro I keep getting the error. And seemingly every time it's a different query that doesn't work. It's not consistent.
I have my computer and all documents as trusted on both of the databases.
Any ideas?
Thank you.