The db is split, BE and FE. I have 3 admins who have no problem accessing the database and 2 users who can access the db but intermittently.
Users can access the db with no errors when the other 3 admins are not running the file.
But once the admins are running the db, the 2 users cannot access even from the FE.
The error message that comes out is usually error 3045 and couldn't lock file.
I have done the following:
1. Set the folder permissions of the users to full control to allow read,execute,delete everything.
2. Had the last owner/pc of the BE lock file (.laccdb) to delete the lock file (but was unsuccessful because the lock file just couldn't be deleted, I believe this is where the problem is). And yes, I've made sure everyone close the db when I'm doing this.
What am I missing here?
I read somewhere
"Users can still be restricted by read only access from the database file permission even if the directory contains write access." from http://www.access-programmers.co.uk/...p/t-80735.html
Surely there is a better way to rectify this?
Thanks