By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,885 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,885 IT Pros & Developers. It's quick & easy.

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

patjones
Expert 100+
P: 931
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...
Oct 19 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.