Automated Deployment of Access .accde, only if newer

[tomtomtom]

Hi!

I am having troubles when trying to deploy updates of an .accde file to clients via GPO:

1. Everytime a user launches the .accde file, the modified date will be updated. This makes it impossible to use a command like xcopy with the /D parameter.
2. When I try to query the creation date of the file and deploy a new version only if the creation date of the source file is newer, the file will be deployed everytime because the creation date of the destination file will not change, also not if the file has been overwritten.
3. Then I gave the Package Solution Wizard a try, but also here I would have to query a custom flag that tells me which version is installed and which version would be deployed.

Is there a simple way to deploy a new .accde file only if it is "really newer", and not only modified? Or any chance to prevent the file to be modified if a user launches it (I actually would assume that from an .accde - executable file...)
How are you managing the automated deployment of updates of Access files?



Thanks in advance!

[June7]

This is my method http://forums.aspfree.com/microsoft-...ue-323364.html

However, I don't deploy accde, just accdb.

[tomtomtom]

Hey June7, thanks for the answer.
So it looks like I cannot pass a custom flag.

[June7]

Not sure what you mean by 'pass a custom flag'.

Your option 3 seems much like what I do. User opens their install of project, code queries a table for version number, if it is different from version on form label, file is copied and replaces user's current version.