How to Open a Form in User Exclusive Mode

[FredCailloux]

I've been building this Access Database with Tables and Forms and I am now getting ready to turn it into a somewhat finish product. I want the Main Form to open in a User Only format. Meaning I don't want the user to access all the building tools and Access Menus. This is probably one of those stupid simple opening option but I just cant find it. Any idea anyone. Thanks

 

[CJ_London]

A very open question. It really depends on what you are trying to protect and to what extent. Basic things to do:

to protect the forms from being modified by the user, create a .accde file.

In settings you can also set a specific form to open, hide the navigation pane and turn off menus.

This can also be done through vba but be aware that any user with a basic knowledge of access will know how to reverse this.

tables should be in a back end so users cannot change them - required anyway if you have multiple users.