automatic update of client

[LH]

Hello. I have an Access .ade client that communicates
with SQL Server on our network. It is a hassle when we
make structural changes to the client application because
I need to go to each users machine and install the updated
client. What would be great is when a new version of the
client is available (some specified place on the
network?), it would somehow automatically replace the old
version of the client with the new one on the users
machine. Does anyone know an easy way to do this?

Thanks for any help,

LH

 

[Bryan Martin]

Because im not familiar with .ade files this may be incorrect. We use .mde
files with a .mdb loading them.

On load of the first form in the mdb I have a sub which runs and date checks
our network drive for updates. This module relies heavily on API's such as
"FindFirstFile", "FindNextFile", "FileTimeToSystemTime" etc... Once a newer
*.mde file is found it is automatically copied onto the client system.

Bryan

 

[Larry Daugherty]

Check out Tony Toews's free utility FE AutoUpdater at:
http://www.granite.ab.ca/accsmstr.htm

hth