Access Lock File issue

[dougancil]

I have a user who is getting the following error when trying to write to an access database:

"Cannot lock file, access.mdb Either the file is in use or the web server is temporarily busy"

I've checked on the server that this file is located on and both the mdb file and the folder the user has permissions to write/edit/delete data from. I've tried searching for what may be the cause of this but I'm stumped. Anyone know of a way to fix this issue?

Thank you.

[oracleguy]

You said it is on a server, could it be that someone else has it open on another computer at the same time?

[dougancil]

I've looked at the shares on that server and I see no users sharing that DB. I have to reboot the server next week anyway. I've read a few forums that suggest that even if no one is sharing that file (and there's no .ldb in the folder) that if someone exited out of whatever program they were using to access the db, that it could have made the server think that that .ldb was still there. I'll post something after Tuesday of next week if a reboot doesnt solve this issue.

[oracleguy]

Yeah, it might have been that the lock never got properly removed. Maybe someone was using it and the program crashed or something and didn't remove the lock.

[_Aerospace_Eng_]

If all else fails look into a program called Unlocker. Its pretty good at unlocking and telling you what has a file locked.

[oracleguy]

If all else fails look into a program called Unlocker. Its pretty good at unlocking and telling you what has a file locked.

I totally forgot about that program. Yeah, you might want to try that program. It might fix your problem without having to wait for your server reboot on Tuesday.