Sign in to follow this  
Followers 0
darbid

how to check for new file

3 posts in this topic

I am a beginner.

I am developing a simple tool which downloads from a networked folder a number of files to a client.

This was all I needed inorder to trigger the download so far.

If FileGetTime("\\gemeinsameablage\LuTTool.mde",0, 1) > FileGetTime(@ProgramFilesDir & "\LuTTool\LuTTool.mde",0, 1) then

When the file on the network has a newer date then it will ask the user to download the new version. BUT I built into my tool a "NOT NOW" incase they were on a slow connection and did not want to transfer the new files at that moment.

I have since noticed that becasue I am useing a MDE (microsoft access database) file for the trigger and that this MDE file is also what the user will use that once they have used the old MDE it will have a date that is after the one on the server. (this is because at close down the mde is re-created)

How would people suggest that I build in a trigger. I have other files, which are rarely if ever updated. Should I just have one of them as a trigger as well. Then if I want to make sure there is an update made i open and resave one of these files in order to change the date?

Share this post


Link to post
Share on other sites



what about some other parameter like file size?? can u use that??


[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com

Share this post


Link to post
Share on other sites

Not really, by "re-create" I mean that Microsoft Access "Compacts and Repairs" itself. It currently is around 23,000KB but can go to 50,000KB during a session and it is not guaranteed that it will go back to the same size.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0