Access 2003: Update front end

[DajTwo]

I have looked at post regarding audomatic front end update.

http://www.tek-tips.com/viewthread.cfm?qid=30072

http://www.tek-tips.com/viewthread.cfm?qid=884708

I also looked in databasejournal.com but the info is also quite old and for '97

However all are above my programming experience with 'bat' files. Is there a simpler way?

At this time, I have a table [tbl_version_server] in the back end with a field called [ver_ser] and a table in the front end [tbl_version_client] with the field [ver_clt]. the back end table is linked to the front end.

At the start of the user application, a code checks if the back end and front end have the same version number, if not, a msgbox appear asking the user to download from the shared server an updated front end.

However I realize that users are either not doing it, or have a tendency to machiavelic stuff without knowing it so I would need to automate the process, removing user intervention.

The user outdated front end location would be "C:\\Documents and Settings\" & Strname (for getusername() ) & ",

And the updated front end is in a shared drive.

Thanks in advance for the help



If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[dhookom]

Tony Toews has a free front-end updater at

http://www.granite.ab.ca/access/downloadsindex.htm.

Duane
Hook'D on Access
MS Access MVP