Security Problem with Access 2000

[Guest]

I recently created an Access database and used the One-Step Security Wizard
to set parameters for users of the database. I printed out the report that
has the user names, personal ID's, and passwords. However, the passwords are
not working. I backed up the database on a CD. However, it requires me to
enter a user name and password and the ones I have are not valid.

I also went into Access and tried to create a new database and it requires
me to enter a user name and password. What can I do to be able to create a
new database without passwords, etc. ?

 

[Scott McDaniel]

I recently created an Access database and used the One-Step Security Wizard
to set parameters for users of the database. I printed out the report that
has the user names, personal ID's, and passwords. However, the passwords are
not working. I backed up the database on a CD. However, it requires me to
enter a user name and password and the ones I have are not valid.

The security wizard creates a backup, so the simplest way is to just use the backup file (it's named with a .bak
extension), assuming it exists. If I'm not mistaken, I believe you can tell the wizard to not create a backup file,
although the default is to create one.

If you have the report with the user information, then you should be able to open the database with that information.
Make sure that you're using the correct workgroup file (the wizard normally creates a desktop shortcut; use that to open
the database).

I also went into Access and tried to create a new database and it requires
me to enter a user name and password. What can I do to be able to create a
new database without passwords, etc. ?

You may be joined to your secured workgroup. Generally speaking, you'd prefer to be joined to the default workgroup file
(system.mdw), as this won't require logins. To check which file you're joined to, open Access (don't open a database),
click Tools - Security - Workgroup Administrator, and see what file you're joined to ... if it's not system.mdw, then
find and join that file (it's in various places, depending on your OS and Access version - do a filesearch for files
ending in .mdw to locate yours).

Finally, I'd encourage you to read up on ULS before trying this again. ULS is a tricky subject, and has tripped up more
than one experienced developer. Joan Wild's page is a good one, and has links to the FAQ as well as Jack MacDonald's
whitepaper on security (which is, in my opinion, required reading for ULS).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Thank you very much Scott. I was able to open the backup just like you said
I could. Now maybe I'll be able to sleep.