You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.
Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.
Check out:
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
You should also distribute a mde to your users, as that disables design
view, and code can not be changed. I you use a mde, then you have to split
your database.....

Signature
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
SteveS - 22 Jun 2007 15:42 GMT
Thanks Albert. I used the startup options and also created an mde file and
the design view is disabled. I've also hidden all the tables, queries etc.
(not that somebody couldn't simply "view hidden" but at least it looks
cleaner, but hopefully they would never get that far.)
Quick question for you - when I created my mde file I did not split my
database. I'm going to be posting it on a sharepoint site so others can make
their own updates when necessary, and the backend would not be available to
them on a network drive (at least not yet). It seems to work fine (but then I
just did it yesterday) - is there a reason I "have to" split it?
SteveS
> You most certainly can, and should hide all of the ms-access interface. The
> options to complete hide and keep people out of the ms-access interface can
[quoted text clipped - 21 lines]
> view, and code can not be changed. I you use a mde, then you have to split
> your database.....