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

  • 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

    Wednesday, May 25, 2016 11:49 AM

All replies