I have a shared database where the back-end sits on a network drive and the front end is on each user's PC. For some reason the database is modifying itself to be a read only database. No changes are made it just changes to read only. The file properties do not show read-only, but when you launch the back-end database you get an error:
"The database "PMO_BE" is read-only. You won't be able to save the changes made to data or object definitions in this database.
This message is sporadic, sometimes I go in and everything works fine.
I checked with our network security team and I am told everyone has read/write/delete access to the drive.
Their is also no LDB file to show that the database is Locked.
I have tried to stay away from using Access security as the users are all over and don't have any savvy when it comes to this stuff. And the last time I used security on a database it was a disaster!
Can anyone help? Is there any way to prevent someone from opening a database exclusively?
"The database "PMO_BE" is read-only. You won't be able to save the changes made to data or object definitions in this database.
This message is sporadic, sometimes I go in and everything works fine.
I checked with our network security team and I am told everyone has read/write/delete access to the drive.
Their is also no LDB file to show that the database is Locked.
I have tried to stay away from using Access security as the users are all over and don't have any savvy when it comes to this stuff. And the last time I used security on a database it was a disaster!
Can anyone help? Is there any way to prevent someone from opening a database exclusively?