Problem with user passwords and accounts in Access 2007...

[patjones]

Good Evening:

So, I wanted to learn a little about user accounts, because on of my databases has been put on a network drive, and I have a need to know who is entering what data into the application. I figured one easy way to do that would be to just create a user account for everyone and copy to the table "CurrentUser" each time a new record is added. Then I'll know who added the record.

To learn this, I went to another site with a tutorial about this stuff and stupidly downloaded a sample database (which happened to have an .mdb file extension, i.e. earlier than Access 2007) which was designed to teach about user accounts and permissions.

So I played around with this database for a while, created some users, set some permissions and passwords, worked with user groups, etc. and everything worked fine.

Then, later on, much to my surprise, when I completely closed out of Access and opened my own project, it asked me for a password with my username that I created in the other database. What's more is that when I got into my project, I found that I was completely locked out of the user accounts and permissions part of the "Database Tools" menu - I couldn't change anything.

Finally then, my question is this: when you make such changes in one project, aren't they supposed to be local to that project? It seems like the changes I made affected Access as an application, period. What is going on here? Thank you...

[nico5038]

Guess this tutorial will answer your questions:
[url]http://www.moretools.com/lessons/access_security.htm[url]

Personally I never use this and I guess you found out why :-)

Nic;o)