By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

HELP - Everything is Locked

P: n/a
Hi All,

I just tried to follow some advice on securing a database. It worked great. So, figuring I learned my lesson, I deleted the original test database file and went to lunch.

Unfortunately, now every database on the entire machine is locked, and I am getting frantic. What must I do to get back to work?

Thanks,
Desperate Chuck
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
> "Chuck Insight" <j.*******@insightbb.com> wrote in message
news:J2Hue.82128$x96.25061@attbi_s72...
Hi All, I just tried to follow some advice on securing a database. It worked
great. So, figuring I learned my lesson, I deleted the original test
database file and went to lunch. Unfortunately, now every database on the entire machine is locked, and I
am getting frantic. What must I do to get back to work?


What do you mean by "every database on the entire machine is locked"? Do
you mean you're always prompted for a password? If so then either:

a) You've modified the default "system.mdw" Workgroup Information File (this
is a bad thing but not terminal) or

b) You've used the Workgroup Admin tool to point your PC at your custom
"*.mdw" Workgroup Information File.

If a) then you need to rename "system.mdw" to, say, "secure.mdw" and
(depending on what version of Access you're using) either replace or
re-create the default "system.mdw".

If b) then use the Workgroup Admin tool to point your PC at the default
"system.mdw".

In either case, to open your secure db you would then need a desktop
shortcut with a command line in the format:

"Full path to MSACCESS.exe" "Full path to your file.mdb" /wrkgrp "Full path
to your secure.mdw"

including the quotation marks.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a

Thanks - This worked. Right after I did this, Access told me that
something was corrupt, and then told me it needed to be repaired. I
jammed in the install CD, and I'm back in business. Again, thanks for
pulling my fat outta the fire. Chuck
*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a

That's nothing. All my databases have restraining orders against me.

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:J2Hue.82128$x96.25061@attbi_s72...
Hi All,

I just tried to follow some advice on securing a database. It worked great.
So, figuring I learned my lesson, I deleted the original test database file
and went to lunch.

Unfortunately, now every database on the entire machine is locked, and I am
getting frantic. What must I do to get back to work?

Thanks,
Desperate Chuck
Nov 13 '05 #4

P: n/a
Alx
"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:J2Hue.82128$x96.25061@attbi_s72...
Unfortunately, now every database on the entire machine is locked, and I am
getting frantic. What must I do to get back to work?


Try replacing your local system.mdw with a "clean" one.

Alx
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.