Viewing just the forms and not the Microsoft Access window...

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

Guest

Is their any way that I can set something up to where the databases form is
the only thing that is being viewed and not the Microsoft Access database
window?

Thanks in advance for your time and help!! :-)

Wayne
 
Leonard,

Have a look at Tools - Startup on the Access menu. Here you can specify
startup options for the database in use, such as hide the database window
and load a particular form.

Another way of doing it is by creating a macro called Autoexec and putting
your startup actions in there. If an Autoexec macro exists, Access will use
it automatically when the database is opened.

To completely lock users from seeing the database window, you need to
disable the shift key. Holding this down at startup overrides all the
previously mentioned options. If you need to do this, reply directly to me
at paul_ doree @ hotmail. com (get rid of the spaces in the email
address - added due to spammers)


Paul
 
My question on this is: How do you get in to make any design changes (as
Admin) if all methods have been bypassed at startup?

Thanks,

Derek
 
My question on this is: How do you get in to make any design changes (as
Admin) if all methods have been bypassed at startup?
Click to expand...

You should have long ago been distributing a mde file to your users. A mde
cannot be modified by the end users even when you don't disable anything,
and don't hide any of ms-access menus.

You can download a sample application where I hid all of the menus in
ms-access (no code, or security was needed to do this). All I did was use
the tools->startup options. You can find this sample here (grab the 3rd
example).

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

After you run the above, you can exit..and then re-enter holding down the
shift key to "get inside" the application and see how it was done.


The only steps further required to finish off the above and get it read for
the users would be to:

Split the database (this again is a must for any serous development....as
how else do you update your users copy of the application).

Create a mde

Disable the shfitkey by-pass

So, in that sample that hides ms-access, there is really only 2 more steps
to do before distributing that example (mde, and shfitkey by-pass). And, as
mentioned, likely the 3rd step of splitting would also be done.
 
Back
Top