passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I was doing a database and trying to put passwords on the database
just to monitor access to the db. problem is that somehow I put a password
on the entire access program and now I can't open the program at all. Any
ideas?

Thanks!
 
Mark said:
Hello, I was doing a database and trying to put passwords on the
database just to monitor access to the db. problem is that somehow I
put a password on the entire access program and now I can't open the
program at all. Any ideas?
Click to expand...

It sounds to me as though you were playing with the standard system.mdw
workgroup file that ships with Access. You need to undo everything you've
done.

Access uses a workgroup file for every session. It silently logs you in as
'Admin', using this system.mdw workgroup. Once you set a password for the
Admin user, the login is no longer silent - that is why you are now getting
a login dialog every time you open Access.

You should log in as Admin, using the password you set for this user. Then
remove all the groups/users you created. Ensure that Admin is a member of
the Admins Group. Then clear the password for the Admin user.

Implementing security is not trivial. You should download and study the FAQ
available at
http://support.microsoft.com/?id=207793

Follow every step outlined or your database won't be secure.

Even once you understand it (or think you do), work/test on a copy.
 
What you did was added a password to the Admin user in your workgroup file.
Simly use the workgroup administrator to rejoin the default (system.mdw)
workgroup file.

If you truly secured your database, when you try to open it with the default
workgroup, you should get an error stating that you cna't access it. If so,
you will need to create a shortcut that includes the appropriate workgroup.

Based on your post, I am betting that you did not properly secure your
database and that the default workgroup will let you have access to the
file. If so, anyone could have copied your file and opened it from their
own PC with no password. You must read and follow (completely) the security
FAQ if you want to secure your database. Not really a good idea to go
alfway with that process.


Rick B
 
Back
Top