File Attributes

[Guest]

I need to link to a file's attributes such that if that file is updated (thus
changing the save date and save time), I can have those attributes reported
back (updated) to an Access table.

Is this possible?

 

[Guest]

Seems to me that you are reinventing the wheel. There are OS auditing tools
available.

 

[Guest]

Jerry is probably right. That being said, this function should get you the
date & time the file was last modified. However, storing that information in
a table may not be a good idea.

Function ShowDateModified(filespec)
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(filespec)
ShowDateModified = f.DateLastModified
End Function

"filespec" is the full path and filename of the file in question. You may
or may not need a reference to the Microsoft Scripting Runtime library.

For more info on the FileSystemObject, see
http://msdn.microsoft.com/library/d...n-us/script56/html/FSOoriFileSystemObject.asp

-Michael

 

[dbahooker]

I dont see anything regarding 'reinventing the wheel'

if it's so obvious; why dont you plz tell us about the plethora of
free, open products that take files' information and push it into a
database

thanks i'd love to find out who invented the wheel in the first place

-Aaron