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

About Security for my Database.

P: 1
Hi,

I have created a Access Database form to enter the Work flow of the workers. I want to give user/admin rights to the Database. For Eg: Anyone can open the Database. They can Work in the Form. But they shouldn't have access to Work on the Backend table which is also in the same database. Is it possible to create a user level for that table. If can't please let me know, any other way to create this type of tool.
Mar 15 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,347
Hi,

I have created a Access Database form to enter the Work flow of the workers. I want to give user/admin rights to the Database. For Eg: Anyone can open the Database. They can Work in the Form. But they shouldn't have access to Work on the Backend table which is also in the same database. Is it possible to create a user level for that table. If can't please let me know, any other way to create this type of tool.
Tools > Security. You can set object level securities but Security in Access is a complicated subject.
Mar 15 '07 #2

JamesDC
P: 66
Tools > Security. You can set object level securities but Security in Access is a complicated subject.
You could do what I did.

I have two seperate Access files, one for the workers to use for inputting data and one for admin to use to evaluate data. The main DB is stored in the Admin version where the Worker version is linked to the Admin DB. By locking the forms and removing all access options on the Worker version they can only navigate through the set up forms in order to input data and cannot gain access to the DB. The Admin one has password forms in it to prevent unauthorized access... albeit these password forms could be easily hacked by someone intending to do harm.

Does this sound like it could work for you?
Mar 15 '07 #3

P: 4
Thanks a lot. It's really working.
Mar 26 '07 #4

Post your reply

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