best way to compare two none ms access files (1 Viewer)

Henryklassen · Oct 9, 2014

I'm trying to find the best practice for comparing two file, what I need to know is has the file changed.
So here's what I'm trying to achieve and my setup
I have a table where I store Parts each part has two files a production file which can be either a dxf, dwg, or iges file (CAD file types). The part will also have a supporting file that contains forming data.
what I want to do is check if Part 1234.dxf is in the Storage folder if not then copy it to the JOBS folder. However if the file already exsist in the JOBS folder is it the latest one
next
If the part is formed then check if the supporting file is in the storage folder if not then copy it to the jobs folder.

SO what is the best way to compare the file?
I'm using MS access 2010

MarkK · Oct 9, 2014

Here's a function that returns the windows DateLastModified attribute of a file.

Code:

function GetFileLastModified(filespec as string) as date
   with createobject("Scripting.FileSystemObject")
      if .fileexists(filespec) then
         GetFileLastModified = .getfile(filespec).datelastmodified
      else
         err.raise 53
      end if
   end with
end function

Hope this helps,

Henryklassen · Oct 10, 2014

Thank you Mark, I will give it a shot this weekend.

best way to compare two none ms access files (1 Viewer)

Henryklassen

Registered User.

MarkK

bit cruncher

Henryklassen

Registered User.

Similar threads

Users who are viewing this thread