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

User access

P: 4
I'm using access 2003. I want to be able to set a DB to have user name's and passwords, which will restrict access to editing specified queries/tables. I'm not sure what I should be searching for. Can someone direct me to keywords/access fields to be able to do this?

Mar 9 '10 #1
Share this Question
Share on Google+
1 Reply

P: 106

1. Set Public Global Variable
2. Create Table of Names, Passwords and user types.
3. Give each type a number that will act as security level indicator
4. When user logs in successfully, set the Global Variable to their security level number.
5. When each form is opened, run an IF THEN ELSE Statement on the global variable to enable or disable commands and textboxes etc.

Hope this helps.
Mar 9 '10 #2

Post your reply

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