File Attributes

#1 (**permalink**) 28-Jul-2006, 08:26 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12158-file-attributes.html

Is this possible?
--
Redglide90

*

#2 (**permalink**) 28-Jul-2006, 08:27 AM

Seems to me that you are reinventing the wheel. There are OS auditing tools
available.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Redglide90" wrote:

> 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.
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12158
> Is this possible?
> --
> Redglide90
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12158

#3 (**permalink**) 28-Jul-2006, 08:27 AM

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)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12158
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/de...stemObject.asp
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12158

-Michael

"Redglide90" wrote:

> 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?
> --
> Redglide90