Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

How lock users out of the tables, queries, reports, etc.

Is there a way to lock users out of the objects in the navigation pane?  I thought that by splitting the database and saving the front-end file as an accdb file this would work but I guess it doesn't.

Any tips?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

A bound and determined can get at things, but you can make it very difficult.  First your app should always be split, even if it's single user.

 Then distribute the "front end" as a MDE/ACCDE and turn off the database container and menus.  Force it into runtime mode by adding code at startup that quits if the app is not running that way.  

 That locks them out of all the design features, and because it is a MDE/ACCDE, they can't get at to code either.

Jim.
Avatar of SteveL13

ASKER

Jim.  Ok.  But questions:

1)  How do I turn off the database container and menus.  

and,

2) How do I force it into runtime mode by adding code at startup that quits if the app is not running that way.

--Steve
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account