How can I encode MS Access Database

[accesser]

Hi

I want a help. I have access database with forms and tables and other objects. What I want is to hide all the objects so the user can not view the forms or any other objects and only use the interfaces that appears to him automatically.

Thanks

 

[tcgaines]

Hi. You can get started here:

Tools --> Security --> User-Level Security Wizard

 

[alastair69]

Another option is to make an mde file but first make sure you have a master copy as you will not be able to change the mde file.

Tools
Database Utilities
Make MDE File

I think this option will only work on front ends, i have not tried to make an mde on a backend, i normally password protect this file.

Hope this is of use to you, Please make sure you have another copy of your database as you will not be able to make any changes.

Kind Regards

Alastair

 

[ssteinke]

You can also prevent them from using the shift key to access the objects.

Holding down Shift