Help on Setting up Security in Access 2010

[Varadu]

Hi All,

I am trying to hide the tables and queries based on the user authentication. I have created a form for user authentication. In the login form (After update event) i have written codes for user authentication based on security levels.

I have written the following code for hiding my table.

CurrentDb.TableDefs("Details").Attributes = dbHiddenObject

It is happening correclty.

Kindly let me know do we have similar codes for hiding forms and macros.

Thanks in advance.

 

[Banana]

I should point out that this won't stop users from seeing the hidden objects if they know how to show the hidden objects via the Option dialog. Thus, this wouldn't be actually securing your objects.

If you just want to ensure your users do not open or mess with wrong objects, converting your file to an MDE or ACCDE is typically sufficient to protect your forms & reports design. They can still make new tables & queries but if you configure your file to always open with Navigation Pane locked or hidden & hide the ribbon and designate a startup form, this is typically good enough for ensuring users only use forms so you can control how users interact with your applications.

But if you need genuine security, then you need to move your data into another data source (SQL Server? MySQL? PostgreSQL?) then use your Access MDE/ACCDE as the front-end client.

 

[Varadu]

thanks for the response. For my understanding can you please let me know the code for hiding the form and macros.