Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

File Attributes

Discussion in 'Information Technology' started by Redglide90, Jul 28, 2006.

  1. Redglide90

    Redglide90
    Expand Collapse
    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?
    --
    Redglide90
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Profiled US Sikh Throws 'Know Me' Challenge Breaking News Jul 25, 2016
    Hard Talk Sikh Musician Racially Profiled At US Restaurant Hard Talk Jul 6, 2016
    India Patna man files defamation suit against son for inter-caste marriage Breaking News Jan 6, 2014
    USA Federal hate crime indictment filed in 'savage' attack on cab driver Breaking News Apr 4, 2013
    Malaysia Bank Islam Files Police Reports Against Chief Economist Breaking News Jan 23, 2013

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    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.
    >
    > Is this possible?
    > --
    > Redglide90
     
  4. Michael H

    Michael H
    Expand Collapse
    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



    "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
     

Share This Page