Search results

Hi guys I have an update, I have Updated the office to 365 and the locking issue resolved. Thank you for the suggestion everyone

Thank you once again for your valuable suggestions. I am currently discussing the upgrade of our office version from 2016 to Microsoft 365, which will provide us with the latest version of Access. If the error persists after the update, I will definitely look into the permissions you mentioned...

Thank you for your suggestion; it worked! The access lock file is deleted automatically after it is been removed. when its on the desktop. However, I've encountered a new issue: I created a BE File and made a copy of the FE on the problem desktop, while keeping the BE file on the server. when...

Thank you for your suggestion! All the computers are using MS Access 2016, which is part of Microsoft Office Professional Plus 2016. However, it's puzzling that only a few of them are experiencing this issue despite having the same version.

Thank you for your suggestion regarding the distribution of the Front-End (FE) and Back-End (BE) in an Access database setup. I understand that having separate FE for each user and a shared BE can help avoid issues related to file permissions and ensure compatibility. However, the issue I am...

Thank you for your detailed response. I will provide a clearer overview of the issue before addressing your suggestions. Current Setup: There are 10 Access database files, each corresponding to a different machine, all stored in a shared company folder. Lets say Machine 1 is one of the computer...

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...