The message is unusually helpful.
It has either been opened exclusive by someone else ....look for a lock file
OR you don't have read/write permissions to the folder containing that file... Check by browsing direct to the file.
However, Access databases should never be run from shared network locations
usually there is a lock file open... .lccdb (on your front end)
delete it then open the .accdb
provided you DO have a split database correct? Each person has their own copy of the Front End.
If you don't have asplit database, then split it.
Hey Ridders & Ranman,
Thanks for your replies.
Yes, it is a split database. And there is no Locked file on my end. I have restarted the computer thrice, But how do I find this locked file??
Look in the folder containing the backend file as that is read only.
If in use normally, there will be a lock file.
If exclusive, there won't be. If so ask IT support to help.
If you can't open the folder, it's a permissions issue
The lock file on the backend is normal and should be there.
otherwise I see no reason for you to be locked out.
and if YOUR Frontend is only used by you,then there should be no problem.
you could try getting another copy of the FE. Sometimes corruption may do it.
Yes the lock file is normal & should indeed be there ...if the split database is being opened correctly by all users.
BUT if someone has exclusively opened the BE file directly from that folder, the lockfile won't exist but you will be unable to write to the file from the FE
Okay... There was a locked backend file. Now its no longer there. But now I still can't enter.
I have tried running it from different front-end database.
I have restarted my laptop again. Still no use.
Can you open the BE file direct ...if nobody else is running the FE?
If not, check permissions.
When others open the FE are there any signs of data corruption?
Where is each user's copy of the FE located? On their own workstation or a shared network drive?
Is anyone else running the exact same copy of your FE? In other words sharing the same FE?