I have a strange issue.
I have an MS Access .mde file that seems to have corrupted on me. The .mde file sits on a network server, and when I try to open the database I get the message...
"The database Cars.mde is read only.
You won't be able to save changes made to data or object definitions in this database."
It appears that a user has locked the database accidentally. But in fact, I can check the processes and there is no one in the .mde file. Add to this, there is no locking file for the .mde file.
I have tried to compact and repair the .mde, and I just get an error saying I cannot compact and repair the file becaue it is read only.
To get around the error, I just created a new .mde file, with a slightly different name "cars_08.mde" and had the users point to the new .mde file. All the issues are resolved.
But now I am trying to figure out how to kill the process locking the .mde file up, so I can delete it off the network server.
Has anyone run into this issue, and if so, is there anyway I can delete the file or kill the locking process?
Thank you for your time.
T.J.
I have an MS Access .mde file that seems to have corrupted on me. The .mde file sits on a network server, and when I try to open the database I get the message...
"The database Cars.mde is read only.
You won't be able to save changes made to data or object definitions in this database."
It appears that a user has locked the database accidentally. But in fact, I can check the processes and there is no one in the .mde file. Add to this, there is no locking file for the .mde file.
I have tried to compact and repair the .mde, and I just get an error saying I cannot compact and repair the file becaue it is read only.
To get around the error, I just created a new .mde file, with a slightly different name "cars_08.mde" and had the users point to the new .mde file. All the issues are resolved.
But now I am trying to figure out how to kill the process locking the .mde file up, so I can delete it off the network server.
Has anyone run into this issue, and if so, is there anyway I can delete the file or kill the locking process?
Thank you for your time.
T.J.