Frequently Asked
Questions
Q: My corporate email
client isn't supported by the Auto FE Updater.
Q: My
users are
getting the
Access 2007
Security Warning
- Certain
content in this
database has
been disabled?
Is there
anything that
can be done.
A: On the
Update - Trusted
Locations page
click the check
box appropriate
to your version
of Access.
Q: I'm getting a
"Open File -
Security
Warning: The
publisher could
not be
verified. Are
you sure you
want to run this
software?"
message.
A: This was
fixed in
version 1.83 and
newer as I
purchased a code
signing
certificate.
Q: Why
does using the
Auto FE Updater
strip the menu
bar from the
Access program
the users see?
And what about
the right click
menus while in
forms?
A: That's caused
by the runtime
switch present
in the
Command Line
entry in the sample
INI files. Remove
that line from
the INI file.
If you are
distributing a
runtime you must
create your own
menu bar.
Distributing the
file in this
fashion is
slightly more
secure thus I've
chosen this as
being the
default in the
past.
Q: I would like the application to use an alternate .mdw file when
starting.
I've placed the /wrkgrp command switch in the CommandLine section, but for some
reason it's not picking the command line up at all.
A: Use StartMethod=FileExtension or StartMethod=AutoSelect.
or
A: Use the StartMethod=FilePath method. However you must also specify the
Shell line. This is a Windows requirement over which I have no control. For
example Shell=C:\Program Files\Office97\Office\MSACCESS.EXE. The
downside though is that your users may have different paths or versions of
Access installed. You can create multiple shortcuts and INI files for the
Auto FE Updater. However this may become somewhat onerous.
Q: Where does the shortcut, .LNK file, reside? The configuration file(s)?
And startmdb.exe?
A: These files should reside in a directory on the server, likely called Auto FE
Updater. They should be be in the same directory as the Auto FE Updater
utility but that's not a requirement. While you can have other files
in the same folder I wouldn't recommend it.
Q: Where do the FE file reside on the server that will be copied down
to the workstations?
A: The FE database files (MDB, MDE, ACCDB, ACCDE, ACCDR, ADP or ADE) must reside in it's own
folder on the server. Along
with any other files you want to copy down to the client in the same folder such
as add-in MDEs or the Leban's PDF DLLs.
Q:
I'm a bit
confused about
the directory
structure
required.
A: You require a
directory on the
server which is
exclusively for
the use of the
MDB/MDE FE which
is to be copied
to the client
directory
whenever it's
updated.
As well as any
other files
required such as
MDE add-ins.
All files in
this directory
will be copied
to the client
workstation.
This is the
MDB/MDE which
you update on
your own system
and then copy up
to the server
when you
complete a
feature or bug
fix.
The shortcut
(which is a .LNK
file),
configuration files
and startmdb.exe
as well as the
backend can be
placed in any
other directory
you desire.
This directory
can contain any
other files you
want to place in
there was well.
However I'd
suggest you
dedicate a
directory to the
Auto FE Updater
and it's
associated
files.
Q: Can the Auto FE Updater also be used on a front end.mdb (instead
of mde)?
A: It can be used with any files. ADPs, ADEs, Word or Excel files, VB or
C++ .exes, etc. All that matters is if a file(s) is placed in the FE
directory on the server with a different date, or a new file, then it gets
copied down automatically the next time the user runs the shortcut.
Q: The workstations are frequently used by multiple users. I don't want
other users' to be able to see this application or have it be accidentally
deleted when the workstation is imaged.
A: The FE should be installed in the users Application Data directory on the
workstation. In the Target screen use the %appdata% environment
variable.
Note that the standard environment variables such as APPDATA, USERNAME and
COMPUTERNAME are (as of version 1.51) supported within the Auto FE Updater
utility.
Q: On the server that I use the variable called %username% instead.
Is that version related or a choice of the administrator?
A: I get the user name using an API call. I chose to use variable names
surrounded by %s in the INI that were the same as the command prompt variables
just for some consistency.
Q: It's not creating shortcuts.
or
I'm getting the message "1030 - Shortcut creation was not succesful for unknown
reasons.:"
A: 1) Can you create shortcuts on your or the users desktop manually by right
clicking? Some IT departments
restrict this capability.
Q: Where do I indicate the location of my security file?
You need to specify the location of the workgroup file in the Command Line entry just as you would when creating a shortcut.
For example /wrkgrp \\server\share\workgroup.mdw
If you are using the StartMethod=Autoselect you will also want to use the
MDWFile option as well so the Auto FE Updater knows which version of Access to
use to open the client FE MDB/MDE. You can avoid this by using the StartMethod
set to File Extension
Q: I have to do some preprocessing in VBScript and then have
different FEs on different servers called depending on where the computer is
located in the WAN.
A: Create a configuration file with the appropriate settings for each of the servers
along with StartMDB.exe. Once you've determined the local server then call
StartMDB.exe using command line parameters such as
"\\server1\share1\StartMDB\StartMDB.exe" /cmd
/inifile"\\server1\share1\Auto FE Updater\<name of configuration file>.ini"
Q: I'd like to add comment lines to the AutoFEUpdater.INI file to
annotate which computer name belongs to whom.
1) The only work station names in the AutoFEUpdater.INI file should be those of
the developers as these entries give those workstation users the AutoFEUpdater
GUI to work with the INI files
2) You can't do it on the individual lines Master1-5 as INI files don't work
that way without extra logic on my part. However you can add additional
lines in the INI file as you wish. These will be ignored by the Auto FE
Updater.
Q: Is there any way to insert a command into the Auto FE Updater .ini
file to tell it to run either a batch file or .exe file before it does anything
else?
Yes, although you can only start a .bat, .cmd or exe file. You can't
then start an MDB/MDE running using the Auto FE Updater. The bat, cmd or
exe file will then have to start the MDB/MDE/etc You can use the
Executable Start Method option.
Q: I'm moving the files from one server to another server.
How do I easily use the Auto FE Updater to get the users to use the FE from a
folder on the new server?
Q: I want to move the BE MDB to a different folder on the same server.
There are two parts to this. One is to replace the FE MDE so it's
linked to the new server path and folder structure and the other to change the
target of the shortcut to use the new Auto FE Updater INI file.
On the day of the switchover delete/rename the BE MDB file from the old server
so just in case something gets missed they can't work with the old MDB file.
You're moving it to a new server anyhow so don't leave it easily available on
the old server.
Copy the new FE MDE which is linked to the new BE server and folder to the FE
path on the old server. This way when the users run the old shortcut for the
first time they will get switched over to the new FE MDE.
Update the AutoFEUpdater INI file on the old server to be the same as the INI
file on the new server. When the users run the new INI for the first time they
will get a warning message saying the shortcut on their system is different. Use
the Shortcut Error Message Handling option set to "Correct problem with no
message to user" on the configuration file on the old server to ignore that
message so the shortcut gets updated transparently to the user.
Use the New INI Path And File entry in the old
INI file. This line is only used
when moving servers or such as this will rewrite
the path and name of the StartMDB exe and INI
file in the target of the shortcut.
This can all be tested ahead of time.
Alternatives to the Auto FE Updater
|
Auto FE Updater 
Granite Fleet Manager
- the best designed fleet maintenance tracking and
management system available
