Access Locked my file

A

About Face Intern

I was working on a database and my computer froze. When I rebooted the
computer and tried to open the file I'd been working on, access said "The
database has been placed in a state by user 'Admin' on the machine "willaft'
that prevents it from being opened or locked." I can't even access the file
from the computer I was working on it from, or from anywhere else. If anyone
has any idea on how I can unlock this file and get access to it, please let
me know. Thanks very much
 
M

MacDermott

Compacting/Repairing the database often helps with this.
But make a backup copy first! In odd cases, the compact/repair may make the
problem worse.
 
T

Tony Toews

I was working on a database and my computer froze. When I rebooted the
computer and tried to open the file I'd been working on, access said "The
database has been placed in a state by user 'Admin' on the machine "willaft'
that prevents it from being opened or locked." I can't even access the file
from the computer I was working on it from, or from anywhere else. If anyone
has any idea on how I can unlock this file and get access to it, please let
me know.
Click to expand...

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top