PLEASE HELP!! Security problem

[krzysztof via AccessMonster.com]

Hello, and hopefully good day to you, but not me...

I have a database that uses and mdw security. i think the problem lies
outside of security, but i really don't know. The link i use opens up access,
but does not open the mdb, and a pop up states that the file cannot be found.
So i checked my syntax and my spelling, and yet still the same. i even
restored the link from backup, no avail. i tried to import into a new
database, and it said that the file was in use by another user exclusively.
there are no ldb's, and i even checked the file usage on my network, and NO
file in that folder is even in use. this is a major db that runs 24 hrs, and
it has been down since 5pm yesterday.


ps - we did have a very brief power outage yesterday around 5pm, but battery
backup took care of servers, but i dont know about users pc's.

does anyone know how to get the lock off the database?

Vey much TIA

~K

 

[krzysztof via AccessMonster.com]

if any one ever encounters this problem, here is what worked for me...

first, copy the mdb, mdw and link files from the network to a pc, ie: making
it local.

then, change the path, and start in: fields to the new location.

open the db with the new link.

close the db, and then copy only the mdb back to the server, replacing the
old file.

now open the db using the link on the network...

hopefully it should work