Access file will only open in "read only" mode on network.

Question

We recently upgraded to Office 365 from 2007.  One of our database files will only open in "read only" mode as the .ldb file is not deleting itself after the access file is closed.  This happens if the file is accessed from a user on the system other than the user where the file resides.  This did not happen with the prior version of access.  The properties are set to be shared with everyone on the network having "full control" and the "read only" attribute is not checked.  I'm sorry if I'm missing information, but any help would be greatly appreciated.

Answer 1

It is more like Office issue instead of SQL Server.

Answer 2

Yes this is MS Access related issue and not SQL Server.

However I have an idea to check whether there is any process running in client system for this application while closing the access file. MS Access might be having events that can track closing of file. Before closing add VBA script to search or read for any Access process running in the task. If it is close it before closing Access File.

---

Regards, RSingh

Answer 3

There are few threads from other forums maybe useful.

http://stackoverflow.com/questions/5954982/access-database-opens-as-read-only

http://www.cnet.com/forums/discussions/access-2007-opens-database-read-only-574384/

https://support.microsoft.com/en-us/kb/324666

I understand why you posted your question here because there is no msdn forum on this. MSDN forum is more on development.

You can post your question to Microsoft Answers http://answers.microsoft.com/en-us/office/forum/office_2007 as well.

chanmm

---

chanmm