Security Problem

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am relatively new with Access.

I have a secure db that I created which up until an hour
ago was working just fine. When I opened the db I was
prompted for my user name and password just like it is
supposed to do.

Now, When I try to open the db, Access tells me I do not
have permission to open the db. I am not prompted for a
password or user name. It just tells me I do not have
permission.

What did I do or what can I do to fix this problem?
 
One of these three things has happened.

(1) You are not opening the database in the same way. (For example, you used
to double-click a shortcut, but now you double-click the actual database
file.)

(2) Someone has used the Workgroup Administrator program to select a
different default Workgroup file, or

(3) A 0.05% chance: one or more files have been clobbered.

My bet is (1). Give us more info!

HTH,
TC
 
I had to open the .mdw file and join (again). Not sure
how this happened but I am very happy that I did not lose
that database. I am fairly new to the Access security so
I am sure this will not be the last problem.

Thanks for you help
 
I had to open the .mdw file and join (again). Not sure
how this happened but I am very happy that I did not lose
that database.
Click to expand...

There's a better way to choose the proper workgroup file. Start each
database using a shortcut, rather than double-clicking the mdb file. The
shortcut uses the /wrkgrp switch to specify the workgroup file to use for
that run. Something like this (all in one line):

"full path to MSACCESS.EXE"
"full path to MDB file"
/wrkgrp "full path to MDW file"

with at least one space around each part.

I am fairly new to the Access security so
I am sure this will not be the last problem.
Click to expand...

Aint that the truth! Access user level security is very capable, but also
fairly complicated, & full of traps for the unwary.
Thanks for you help
Click to expand...

No probs :-)

TC
 
Back
Top