Years ago I wrote a series of programs using MS Access 2007 that are linked to a common back end. Just recently someone else I know has made some enhancements to the programs (I was too busy to do them). He is using MS Access 2010 and has now come across a strange situation. Every now and then (happened twice) his backend database opens as read only.
The issue is
• Backend opens read only and unable to make it write access.
• Could not perform Compact and Repair
• But when copied out of that directory, backend opens properly without read only warning.
• No .laccdb file exists in the directory
Has anyone come across this before? Any suggestions?