Keeping track of the version.

[Ana]

Hi,
I often update the .ade file (connected to MSsql) in a file sharing server
so that the users can download a copy. The updated file always has a new
name (ex. V.20061120).
I was wondering if there's a way to notify a user when a new version is out.
Perhaps via a query or a stored procedure triggered when they boot the older
file.
TIA.
Ana

 

[dbahooker]

you can write a vbs file that automates looking for the newest version
and then launching it

-Aaron

 

[Sylvain Lafontaine]

Maybe the AutoFeUpdater utility could work for you (you will find other
alternatives at the bottom of this reference) :

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

Another possibility would be to put the ADE file on a read-only location and
create a shortcut pointing toward a batch file that will copy every time the
file to the local hard drive of the user before launching it. Should work
if you are making an update only when no one else is logged.

 

[dbahooker]

wow you know.. i probably wouldn't have been so hard on those kids if i
knew that they supported updates to ADP files

-Aaron