At the moment I have a Split Database with the fron end program on each PC, when I do a change in the front end I place a copy of the changed program in a central location on the server, I then send out an email for everyone to copy it into their specified directoy on the PC and when they run it the Main Menu has a New Version number on it.

That works fine most times but people forget to update.

My question is, how can I get the program on startup and check the current version against what is on the server and if required update the front end automatically??

Any suggestions would be appreciated.

Ross

To force a user to copy the update, you would need to add a version control check in the front end.


I like to use this:
Auto FE Updater (http://www.granite.ab.ca/access/autofe.htm)
It is the best solution I have seen for setting up a new workstation and copying multiple files.
***Note: It can be implemented without any changes to your current database.


For an Access based one, Here is One by Bob Larson (a member here)
FRONT-END AUTO-UPDATE ENABLING TOOL (http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx)
Note: I have never used it, but I have seen it recommended here in the past.