Answered by:
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.Tuesday, May 24, 2016 4:10 PM
Answers
-
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
- Marked as answer by Sam ZhaMicrosoft contingent staff Wednesday, June 1, 2016 12:03 PM
Wednesday, May 25, 2016 11:49 AM
All replies
-
It is more like Office issue instead of SQL Server.Wednesday, May 25, 2016 8:24 AM
-
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
- Marked as answer by Sam ZhaMicrosoft contingent staff Wednesday, June 1, 2016 12:03 PM
Wednesday, May 25, 2016 11:49 AM -
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
Sunday, May 29, 2016 6:20 AM