Access to tables while form is open

Gr3g0ry

Registered User.
Local time
Today, 06:59
Joined
Oct 12, 2017
Messages
163
ive already figured out how to load a form as access opens, so is there a way to force users to use the forms and deny them access to the tables ?
 
To Hide your database navigation window use the following VB in your forms open event

DoCmd.RunCommand acCmdWindowHide

The following makes the navigation window visible again

DoCmd.RunCommand acCmdWindowUnhide
 
You could make the form modal.
 
If you only have one form, it's relatively easy. More than one form, gets trickier.

You can search this forum for "securing a database" for lots of details.

In summary, you need to hide the ribbon, disable the Access "special" keys that let you bypass the startup sequence, define a startup form, and put code in that form such that if you try to leave the form, it quits the application.

For these topics, search for:

hide ribbon
node navigation pane
define startup form
disable bypass key
close application from event code

IF you have more than one form, then you create what is called a "switchboard" and make it ALWAYS present via the methods discussed above. Then you create other forms to be launched by command buttons that perform the "OpenForm" operation. (There is a command button wizard option for that function if the targeted form already exists.)

If you are using a switchboard or dispatcher form then you don't care if the user exits the forms loaded via command button. You only care that the switchboard stays in place like a blocker. And the only "Exit app on Close" trap is on the switchboard in that case.
 

Users who are viewing this thread

Back
Top Bottom