469,091 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,091 developers. It's quick & easy.

Access security - closing the back door

3
Hi - I am new to the forum.

I starting developement on an application where the user level security is such that I need to restrict access to individual fields in a table.

I am familiar with Access Security and workgroups, and setting up forms limiting the fields that are showing.

But I am concerned about the back door. How do I prevent a user from opening the database window and looking at all of the data in the table?

If I restrict access to the table, then the query with limited fields will not work either.

I have also tried changing the table properties to hidden, but a user without admin access can use the menus to go to options and view hidden tables.

I can close the database window in startup, block use of the F11 key, and even limit the menus, but any user can bypass the startup with the shift key. And then all is revealed again.

Now I don't think these users will have any idea how to do this, but that is still a whole in security for confidential information.

I know that I can split the data into many tables and restrict that way, but it is looking that that option may be a nightmare.

So is there a way to keep certain users out of the back door, while allowing admin users access? I've been all through this site, and can't find the exact answer.

Thanks much for your help.

Sandy Zohari
Oct 6 '06 #1
1 2296
PEB
1,418 Expert 1GB
Hi,

Shift key maybe set to be not bypassed...

For my application it's like this... And I also can't access the database!

But it's all that I'll tell you don't ask for more! It's up to you to search for it...

:)
Oct 8 '06 #2

Post your reply

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

Similar topics

25 posts views Thread by KK | last post: by
22 posts views Thread by alecjames1 | last post: by
7 posts views Thread by Tumurbaatar S. | last post: by
4 posts views Thread by tony | last post: by
9 posts views Thread by G .Net | last post: by
1 post views Thread by nancy | last post: by
22 posts views Thread by teejayem | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.