open an access program with Windows viewer showing only forms

[shedendcfc]

New to access 2007, how do i create a short cut on my desk top that only
opens the program with forms and reports, not via access which gives access
to total program and the files / tables, i just want to run the program i
have designed

 

[NG]

Hi,

if you don't want to show the tables, code ect... you can:
* hide the database window in the "Access Options" window -> "Current
Database" .
* make an accde file from your database using the option Database Tools ->
Make accde file
* Make an accdc file with the publish -> package and sign option.

You can download and install this last option from the microsoft site.

 

[Albert D. Kallal]

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
(there is a 2007 version also)

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

 

[David W. Fenton]

You most certainly can, and should hide all of the ms-access
interface.

While "can" is true "should" depends on the particular application
and its user population. For what it's worth, I hardly ever hide the
default menus/toolbars. Nobody notices, nor cares.