Hidding Tables to end users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

Can one hide the underlying database from end users ?.

What I mean is the following. When one opens an Access database, one has the
'Objects' screen that allows one to view existing tables, queries, forms,
etc. Is there any way to hide that so users can only see the forms of the
application/database in Form View and they have no access to the tables
directly and the cannot switch to Design View ?

Thank you very much.
Cheers
 
You can run this code to hide the object window when the application runs

docmd.RunCommand acCmdWindowHide

And then you can create a macro called AutoKeys to disable the F11 key that
brings the database window back to the front
 
Fernando said:
Hi there,

Can one hide the underlying database from end users ?.

What I mean is the following. When one opens an Access database, one
has the 'Objects' screen that allows one to view existing tables,
queries, forms, etc. Is there any way to hide that so users can only
see the forms of the application/database in Form View and they have
no access to the tables directly and the cannot switch to Design View
?
Click to expand...

Tools Startup has all the options for this. Of course it only hides stuff from
people who don't know how Access works. If that decribes your users it should
be sufficient.
 
Tables have a property that allow you to hide them, but your users will be
able to see them again if they select the Show Hidden Objects setting under
Tools | Options in the menu. You can, however, apply Access User-Level
security to prevent them from having access to the tables.
 
Ofer, Rick, and Brandt thank you for your replies.
The have all been very helpfull.

Cheers
 
Back
Top