1) These are Global Options, so setting them will affect how Access works on
that machine. They will affect every database. In some cases, they will
affect other MS Office applications. If this is a concern, you can set them
back when the application closes.
2) I always have a main form (a switchboard) that opens and never closes
until the application does. I put the code in the OnOpen event of this
form. (I also have this form start automatically via the StartUp options.)
Some people have a Splash screen that opens when the database opens and then
hides after a certain length of time. This is also a good place to put it.
--
--Roger Carlson
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L