Distribute MDB file automatically?

[Dave Reardon]

I currently have a database application which is used by staff for pupil
records. It is a split database with connections to a number of SQL server
tables. I distribute front end updates to each staff machine via a program,
but wonder if there is a better way that would look at the time stored in a
local table, compare it with the time of last update on the server table and
automatically go to the network location and update the local copy if it is
newer. I have seen this somewhere on the net, but I can't find it...

Dave

 

[Dirk Goldgar]

I currently have a database application which is used by staff for pupil
records. It is a split database with connections to a number of SQL server
tables. I distribute front end updates to each staff machine via a
program,
but wonder if there is a better way that would look at the time stored in
a
local table, compare it with the time of last update on the server table
and
automatically go to the network location and update the local copy if it
is
newer. I have seen this somewhere on the net, but I can't find it...

There are a couple of solutions along these lines that have been posted.
Tony Toews' Auto FE Updater comes to mind:

http://autofeupdater.com/

 

[Tony Toews [MVP]]

I currently have a database application which is used by staff for pupil
records. It is a split database with connections to a number of SQL server
tables. I distribute front end updates to each staff machine via a program,
but wonder if there is a better way that would look at the time stored in a
local table, compare it with the time of last update on the server table and
automatically go to the network location and update the local copy if it is
newer. I have seen this somewhere on the net, but I can't find it...

Dirk mentioned my utility. It actually looks at the updated data/time
of the file on the server and compares that to the date/time of the
file when it was copied to the local PCs. After all as the user
works in the Access FE that activity alone updates the local PC. If
it sees an updated version on the server it copies down the file from
the server.

The AutoFeUpdater doesn't actually look inside the MDB/ADP itself. It
just looks at the date/time of the entire file.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/