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

Locking user access to the database objects (MS Access 2003)

meLady
P: 27
Hello,

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

Please help me in this case ... the users are ruining and playing all my data.
Apr 15 '07 #1
Share this Question
Share on Google+
5 Replies


ADezii
Expert 5K+
P: 8,633
Hello,

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

Please help me in this case ... the users are ruining and playing all my data.
The fastest and easiest, although not the most effective, method of not allowing Users to see various Database Objects is:
  1. Select Object(s) in the Database Window.
  2. Right Click on Object then Properties.
  3. Click on attributes ==> Hidden Check Box.
  4. The Object(s) will no longer be visible in the Database Window.
  5. You should disallow certain Menu/Shortcut Menu Options so that savy Users cannot reverse the process and Uncheck the Hidden Attribute.
  6. These steps are just a band aid and are not meant to replace a comprehensive Security System on your Database.
Apr 16 '07 #2

meLady
P: 27
Thanks, it was very useful ... you were a big help (^_^) but don't get tired of my questions .. because I am a very naughty person (^_^).

Anyway, thanks a lot for your concern and assistance. If there is any better way to apply band security to my (B) Application, please provide I would be more delighted to learn it and will be tracking every reply.
Apr 16 '07 #3

ADezii
Expert 5K+
P: 8,633
Thanks, it was very useful ... you were a big help (^_^) but don't get tired of my questions .. because I am a very naughty person (^_^).

Anyway, thanks a lot for your concern and assistance. If there is any better way to apply band security to my (B) Application, please provide I would be more delighted to learn it and will be tracking every reply.
Applying User Level Security to your 'B' Application wouold be the opimal way to secure but definately not the easiest. You can attempt the:
  1. Tools
  2. Security
  3. User-Level Security Wizard
  4. If you do this, make a backup copy of your database and also your System.mdw (Workgroup) file.
  5. BTW: I left you a message concerning your other problem
Apr 16 '07 #4

meLady
P: 27
Hello ADezii,

Thanks for your kindly reply ... the answer that you provided me was very useful because it is full of critical things ... but it requires me to read every single word to know and choose what suits my requirements ... but if you see that is it right for me to learnt it and use it for my (B) Application .. then I am ready for the extensive learning (^_^).

Again ... Thansk a lot
Apr 17 '07 #5

ADezii
Expert 5K+
P: 8,633
Hello ADezii,

Thanks for your kindly reply ... the answer that you provided me was very useful because it is full of critical things ... but it requires me to read every single word to know and choose what suits my requirements ... but if you see that is it right for me to learnt it and use it for my (B) Application .. then I am ready for the extensive learning (^_^).

Again ... Thansk a lot
Anytime, meLady.
Apr 17 '07 #6

Post your reply

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