Security Access Db..

[HRakibul]

hello guys,
i need to secured my access database through Code. How would i do that.
i have several forms and i wish the user only can see those forms. they cant enter into the design view or any table or any where.

and off course the navigation panel should be locked by code and ony i can enter into the code. all the tabs should be locked by code.

i m Using Ms Access 2007 . is it possible in this version, if anybody plz help.

 

[Prashant]

Hi,

You need to set the access level table first and then give them rights for e.g. "User" "Admin" and based on the same you can provide them access to your various forms.

If you want to make the things more simple, just use a login form at the start of your access database. Based on the login you can give them access.

For navigation etc. you can go in the options and select current database and can use the options according to your need.

 

[ButtonMoon]

hello guys,
i need to secured my access database through Code. How would i do that.

If by "access database" you mean a Jet/ACE database then it can't be done. A Jet/ACE database is completely exposed to anyone who can open it. Hiding data behind code won't help unless your intention is to deceive your users into thinking their data is subject to a level of security that in fact it isn't.

If role-based security is a requirement then move your data to a client-server DBMS with the proper security features built in. You can still use Access for your application of course.