Updating the front end

[Guest]

I've read that it's best practice to keep the front end of a db on the users
machines rather than on the network.

What is the best method of ensuring that the individual copies are up to
date? Copying from the network to their machine as part of the login script?
or can it be done within Access?

 

[Douglas J Steele]

Nothing built into Access, but take a look at the free Auto FE Updater Tony
Toews has at http://www.granite.ab.ca/access/autofe.htm

 

[James Goodman]

I got round this by incrementing a version number (which forms part of the
application title) whenever a change is made. A history of version numbers
is stored in the DB, & when a user opens it, the most recent number is
compared to their version number. If they do not match, they are given a
message to copy the latest version & stopped from doing anything else.