How Not To Have To Go To Control+G > Tools > Reference > DAO >Etc.

[doyle60]

Everytime I want to update my 50 or so users' Access, I have to go in
and do a DAO fix:

Control+G > Tools > Reference > Click off DAO 2.5 and go back
in a click back on.

This is turning out to be a pain in the butt. What can I do to avoid
having to do this?

I have Access 97.

Some computers don't need me to do this (the older ones, I guess), but
most do.

Matt

 

[Vincent Verheul]

Hi Matt,

Maybe a good strategy is to:

- split your Access application into a Front-end (appication with Forms,
Queries, Visual Basic / Macro's) and Back-end database (Tables / data)
- put the Back-end database on a shared server
- Save the Front-end as MDE ('executable')
- put the Front-end MDE on a special place on the server (just as a source
to copy from to each local computer)
- use the AutoFEupdater tool (see below) for each user to get a copy from
the source Front-end and execute locally

Vincent


See also message news:[email protected]...

Hi,

If you want to manage Front-end versions in a multi-user environment
there is an excellent tool called the Auto FE Updater by Tony Toews, have
a
look at www.autofeupdater.com Your users will start this little program
(StartMDB.exe) via a desktop shortcut that you have placed on the central
server. They will not start your Front-end Access application directly.
StartMDB.exe will read the .ini file that you have configured. Here it
will
find where your master copy of your Front-end is located. A first time use
will cause StartMDB.exe to copy the master copy to a local folder on the
user's computer and start it from there. Any subsequent call to
StartMDB.exe
will compare dates and do a new copy as necessary to make sure the user
has
the latest version. The users don't need to know where you have put your
back-end at all. You make sure that the Front-end is linked to the correct
location for the Back-end. Works perfectly!

Vincent

 

[doyle60]

But we do that already; it is split.

Thanks,

Matt

 

[Vincent Verheul]

Hi Matt,

Do you also use the MDE format?
Maybe an issue of combining Access97 with a modern version of Windows / Ms
Office?

Vincent

 

[Douglas J. Steele]

DAO 2.5? Do you mean DAO 3.5?

If you've split your application (as you say you have else-thread) and are
running into this problem, odds are the machine on which the application was
developed has a different version of Access 97 than on the other machines.
Make sure that all service packs/patches/etc have been applied to all.