Newbie...Huge problem

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,

I accidentally set a password for access through the
security wizard in Access 2003. I know the name and
password but I cant login. I dont know what happened.
I had wanted to set user ids and passwords for my own
database and not the entire Access program.

Name: LChan
Personal ID: kdebIVp4lWSwYr0cSH1
Password: sunkist
Groups:
Admins
Backup Operators
Full Data Users
Full Permissions
New Data Users
Project Designers
Read-Only Users
Update Data Users

This is one of the users but I cant login with this name
and password. I got this info from a security report
after the security wizard was done.

Please help!!!
 
Are you joined to the workgroup in which you created this userid? My guess
would be "yes" since it is asking you to log in.

It does not sound like you followed the steps in the security FAQ. This
means that your database fiels are not tied to the secured workgroup and
therefore, could be opened with any workgroup.

If you have other computers available, simply copy the default system.mdw
file from a peer's computer and replace the one on your system. You should
then be able to open the database without any password or userid. **MAKE A
BACKUP COPY OF YOUR MDW FILE BEFORE YOU OVERWRITE IT**

After you have done this, read and re-read the security FAQ and follow each
step to the letter.

Make sure to create backup copies of your database before you secure it.

Rick B


Hi,

I accidentally set a password for access through the
security wizard in Access 2003. I know the name and
password but I cant login. I dont know what happened.
I had wanted to set user ids and passwords for my own
database and not the entire Access program.

Name: LChan
Personal ID: kdebIVp4lWSwYr0cSH1
Password: sunkist
Groups:
Admins
Backup Operators
Full Data Users
Full Permissions
New Data Users
Project Designers
Read-Only Users
Update Data Users

This is one of the users but I cant login with this name
and password. I got this info from a security report
after the security wizard was done.

Please help!!!
 
Are you getting a login prompt? The 2003 wizard created a desktop shortcut
to open your database with - are you using that?
 
Back
Top