Date of file movement or copied

[Guest]

Does anybody know if Access 2003 records the date at which an access file
(aplication) was copied to a directory? If it does how can I access it.
I am trying to build a security system which will ask for a code number a
certain period after the file was copied to a new directory.
Thanks in advance

 

[Joseph Meehan]

Does anybody know if Access 2003 records the date at which an access
file (aplication) was copied to a directory? If it does how can I
access it.
I am trying to build a security system which will ask for a code
number a certain period after the file was copied to a new directory.
Thanks in advance

Access does not (at least I don't think so, but Windows does record
information about all files.

 

[Larry Daugherty]

That would require that the file be "aware" when anything was done to
it and intelligent enough to know what was done to it. When files get
that smart and capable we'll have bypassed the point where machines
would have taken over the universe and we'll have surrendered directly
to the software. })

 

[Guest]

Does anybody know if and how I can access this date from Access?

 

[Douglas J. Steele]

Randy Birch has sample code at
http://vbnet.mvps.org/code/fileapi/filedatetime.htm

Obligatory note: Randy's site is aimed at VB programmers. There are
significant differences between the controls available on forms in VB and
those in Access. That means that some of his examples will not port directly
to Access. Looking at this particular one, though, you shouldn't have any
problems.