Search results

First, I want to sincerely thank you for your incredibly detailed and insightful response. Your explanation of security permissions, Access Control Lists, and how Access handles locking mechanisms was extremely helpful. I really appreciate the time and effort you put into it.After reviewing the...

No i went to each of the computers where there was an issue and I created an new empty access file. When I tried to open it and close it the lock file remains. Also if the file is open it cannot be copied as well.

I created empty access file with no data ,tables and form just and .accdb file and the file was locked.

Thank you for the suggestion. I tried creating and deleting files in the folder containing the database, and I didn't encounter any issues. It seems that the permissions are set correctly for the users.

Thank you for your suggestion. I checked the options, and it's not set to open in exclusive mode by default. Additionally, I'm not using a shortcut to open the application.

I am experiencing a persistent issue with Microsoft Access that is affecting multiple users in our environment. Specifically, when any database file is opened on four particular computers, it becomes locked, preventing access from any other users. Even after closing the application on these...