File access date - TechRepublic
General discussion
January 21, 2003 at 06:03 PM
g. basson

File access date

by g. basson . Updated 23 years, 3 months ago

I am building an MS Access application (with Visual Basic coding) which populates a table with a directory’s contents. It lists all the folders and sub-folders (for a directory on the network) and the files in each. I have managed to get the modified date with the FileDateTime statement.

I’ve also looked on the MS knowledge base for obtaining the date created / modified / accessed. The solution they proposed involves opening a file handler and obtaining the dates through functions that use ‘Lib “kernel32″‘. It works well, but fails to open a file handle roughly 50% of the time.

Does anybody have a better solution to obtaining the dates mentioned above? I am looking for a freeware product or using VB code in MS Access.

Thank you.

This discussion is locked

All Comments