I'm running vbscript on a server over Citrix in order to move the file (Access file in this case). File assessment all has to be done before Access fires up. I'm trying to copy over an Access file if it has been changed. I'm using a script and the filesystem object.

In assessing the file, I'm having trouble figuring out how to determine whether to copy a new file.

I though perhaps the Date Modifiled would be a good comparison variable, but the problem with using Data Modified is that if I change a table in the Access file (not the code), the Date Modified gets updated, and hence the user would be updating every time.

The Date Created was an option, but this seems to be static once the file exists in the folder (doesn't get updated, even if deleted then readded).

I moved onto File Version of the file, thinking this might be an option. I can use GetFileVersion to find what it is, but I can't seem to find out where to change it for my Access file. Is this through the Access applicaiton? Some property on the file properties area?

Any help is appreciated!

I handle this internally through a custom DB property... I'm not sure what GetFileVersion does exactly, but I'm not aware that Access has any built-in version increment system, so I'd feel a bit safer using my own.

Whether you want to use a DB property or a Constant with a public function wrapper to retrieve it, either would work. I opted for the DB Property route so my distribution utility can update it for me.

hth