Home All Groups Group Topic Archive Search About

Security Wizards in Access 2000?

Author
27 Jul 2006 9:05 PM
Gisselle
I have created a little database in Access 2000.  I used security wizard to
try and secure the database.  Now I am locked out of the database.  It is
sending a message that I do not have the correct permissions although I
created the thing.  How do I undo security wizard or restore permissions?

Author
27 Jul 2006 9:25 PM
PadmaBhaskar
Try renaming the workgroup file it created (the MDW file) to some other
name, so that next time you open Access, it would point to the
system.mdw file and will not lock you out.

I would recommend doing the security settings manually, rather than
using the security wizard. This is a very good article:
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

Hope this helps! Good luck!

-
Padmaja

Gisselle wrote:
Show quoteHide quote
> I have created a little database in Access 2000.  I used security wizard to
> try and secure the database.  Now I am locked out of the database.  It is
> sending a message that I do not have the correct permissions although I
> created the thing.  How do I undo security wizard or restore permissions?
Author
28 Jul 2006 1:23 PM
Joan Wild
The wizard may have created a desktop shortcut to launch the mdb.  Try using
that to start the database.

--
Joan Wild
Microsoft Access MVP

Gisselle wrote:
Show quoteHide quote
> I have created a little database in Access 2000.  I used security
> wizard to try and secure the database.  Now I am locked out of the
> database.  It is sending a message that I do not have the correct
> permissions although I created the thing.  How do I undo security
> wizard or restore permissions?
Author
3 Aug 2006 2:16 AM
JD
I am having the same exact problem, how did you make out?

Show quoteHide quote
"Gisselle" wrote:

> I have created a little database in Access 2000.  I used security wizard to
> try and secure the database.  Now I am locked out of the database.  It is
> sending a message that I do not have the correct permissions although I
> created the thing.  How do I undo security wizard or restore permissions?