About Security for my Database.

[Laiqur Rahman]

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.

[Rabbit]

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.

[JamesDC]

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?

[billaiqur]

Thanks a lot. It's really working.