locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a HD that crashed while an access database was in use. I moved the
drive to another machine to simply copy the database, but I'm getting error
messages. If I try to copy the database, I get an error message "access
denied". If I try to open the database I'm told it's in use by another user.
I deleted the Access.LockFile.9, and I can move, and change anything else in
the directory.

Does anyone have any ideas how I might salvage this database. Found out the
user hadn't checked to make sure the backups were working and the last good
ackup is a month old. A lot of changes have been made since then.

Thanks
Rick
 
Was the database secured? If so, you need to find the original .mdw file, or
have a list of the PIDs so you can recreate it.
 
What is the mdw. file, and where would I find it? PID's... that sounds real
familiar, but I'm a bit rusty. Can you help me out?

Thanks again.
 
Teh mdw file is the security file which is present whether ot not you've
created user-level security. The default name for the mdw. is system.mdw and
in later versions it is found at C:\Windows\System32\system.mdw but it could
be named almost anything and be almost anywhere. Not only that, you can have
multiple mdw's for different databases. To find the one you're currently
logged into try opening Access without a database, and going to Tools ...
Security ... Workgroup Administrator.

Some databases have a shortcut which opens that database using another
Workgroup.

The PID or personal identifier is an alphanumeric string created for each
user and group in a secure Access database. If you haven't stored it
somewhere, you are out of luck because it cannot be retrieved.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Rickl8327 said:
I have a HD that crashed while an access database was in use. I
moved the drive to another machine to simply copy the database, but
I'm getting error messages. If I try to copy the database, I get an
error message "access denied". If I try to open the database I'm
told it's in use by another user. I deleted the Access.LockFile.9,
and I can move, and change anything else in the directory.

Does anyone have any ideas how I might salvage this database. Found
out the user hadn't checked to make sure the backups were working and
the last good ackup is a month old. A lot of changes have been made
since then.

Thanks
Rick
Click to expand...

You may want to look to see if you have a YOURFILENAME.LDB file along
with the YOURFILENAME.MDB file. If so try deleting the LDB file.
 
Back
Top