MS Access Security

[Sher42]

I have multiple databases in a single folder. I am trying to learn how to secure a database. I used the Security Wizard to protect one of the databases. Now I cannot access any of the databases. A log on box opens with my user name and requests a password. I do not remember creating a password. The Security Wizard Report lists my name as a User under a Group named Admins but the password field is blank. There is also a user name admin with a 12 character password.

How can I access the databases? Can I turn off security, copy or convert databases so general access is available? I use MS Access 2003 Pro

Frustrated in learning??

 

[Remou]

Search for a Word document called swz_rptSecure.rtf. Access will have strongly recommended that you save such a file. My version is 2000, so there may be some differences in naming.

 

[TheAceMan1]

How are ya Sher42 . . .

What version access?

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[lameid]

Unless you really don't care about your security, this is a last resort option. So definitely try to find the file Remou suggested. Also it may not work at all.

I've never used the security wizard but...

If Admin or the users group has has at least Read Design and Read Data permission to everything, you should be able to import everything into a new database file using a different or default workgoup.

Note: The admin user and users group is the same accross all workgroups. The default group ADMINS however is different accross each workgroup.

 

[JeremyNYC]

Have a look at the stuff on my site:

http://abcdataworks.com/security.htm

DEFINITELY read the white paper before doing anything with security.

---
Jeremy Wallace
ABCDataworks
You can find us on the web, and my e-mail is fairly easy to guess.