Hiding linked tables from users

[RGordy]

Situation- Have created one database with only datatables and a second database with the forms, reports, modules, etc. that is linked to the first database, and have compiled them into a run time version. Would like to prevent users from accessing the datatables. Is it possible to password protect the datatables database and have the other database pass the password to it to open it up??? Or is there someother way??? My wish would be to prevent the users from having access to anything other that using the runtime version.

Thanks for your help.

 

[danvlas]

That depends on what exactly you want to prevent: accidental use of tables or 'evil' user access.

The former: hide the database window and disable Shift (create/set AllowBypassKey = False).

The latter: user-level security, change the owner of the tables to an account that has read (or write) permission, deny any other user access to the tables and base your objects in the front end on queries/SQL statements WITH OWNERACCESS OPTION. All forms/reports will have the right to work with the table data even though the user logged on does not have such rights.

This will drive the 'evil' user crazy...

Good luck






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Rick39]

Add the prefix "Usys" to your objects - they'll be treated as system objects (defaulted to hidden)

 

[JeremyNYC]

I'm with Dan on this, with two caveats: Access security takes a little while to learn (get the FAQ from MS or my site) and if you're truly evil you can in fact subvert it.

But it's still the best way to go, unless you have dopey enough users to count on them never figuring out that using the shift key will get them to the database window.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.