Re: Security Problem with Access 2000

On Fri, 15 Jun 2007 19:31:00 -0700, Shar <Shar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • Re: Security Blunder
    ... passwords I setup dont work... ... but part is stored in a workgroup file. ... >> database on my system...All I get is the logon window with ...
    (microsoft.public.access.gettingstarted)
  • Re: How secure is a secured database?
    ... I'm pretty confident that I've covered the guidelines in the Security setup ... While the main database will have the sensitive cost issues - i.e. their ... the plaintext passwords from a workgroup file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Pathname to access and usernames in shortcut
    ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords. ... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ...
    (microsoft.public.access.security)
  • Re: security issues
    ... It was obviously never meant to be; multiple defences against it being ... The Ubuntu installer uses a framework called debconf to do ... when you're asking for passwords ... you take a lot of care to clean them out of the database ...
    (Ubuntu)
  • Re: Locked Out
    ... deleted because my database was corrupted. ... to put in my passwords or anyone elses (I set them all up so I know ... System.mdw is the default workgroup file. ... Try searching your computer for all files ending in .mdw, then try joining those workgroups and logging in. ...
    (microsoft.public.access.security)