|Home Basic Info Download About|
|Basic Info Wizard Update Config File Forms Enterprise Edition|
Update Configuration File - FE Started by User?
The problem is that users can start the Access FE
database file directly bypassing the
version updating that the Auto FE Updater performs. In particular in Windows 7
and Windows 2008 Server R2 users can pin the Access FE database file to the task
bar and start your Access app directly.
While this feature is great for other applications, such as pinning frequently used Word Or Excel files, it's bad for Access front end database files which are updated from the file server.
In Windows Vista and older operating systems it is possible, but considerably more
difficult, for users to
locate the FE on their own system and start the FE directly. This problem
could also be caused by folks using the My Recent Documents list. (I
don't recall any emails from anyone on this problem.)
If this special command line value is not found then the
code in your Access app starts up the Auto FE Updater exactly as though the user had
clicked on a shortcut and then closes down your Access app. Now the Auto FE Updater
does it's processing, if any, and starts up the Access FE database
file passing in the expected value.
All the user sees is a brief flicker as Access shuts down and starts
Actions required in your Access database front end.
Import the code module zmdlAutoFEUpdater into your Access FE.
As the very first
item in your startup routine insert the following line
Your startup routine will either be a function called by the autoexec macro or your startup form as specified in your startup options.
If you would like to display a message to the user on exiting your app you can
use the following:
Other options will be added to the code module in the future.
Granite Fleet Manager - the best designed fleet maintenance tracking and management system available
Website copyright © 2001-2012 Tony Toews