LastUpdated problem

[Ron]

I found a Microsoft document explaining that
the .LastUpdated property cannot be accessed from MSAccess
2000. Has that oversight been rectified in subsequent
versions? Has anyone found a workaround?

 

[Tim Ferguson]

I found a Microsoft document explaining that
the .LastUpdated property cannot be accessed from MSAccess
2000. Has that oversight been rectified in subsequent
versions? Has anyone found a workaround?

Works for me:

? currentdb().TableDefs("A").LastUpdated
20/07/2004 17:08:49



Do have a reference set for DAO? .Lastupdated is not part of the data model
so it won't be visible to ADO.

HTH


Tim F

 

[Guest]

Yes, there is a reference to the DAO 3.6 Object Library.
We're not currently using ADO.

I don't have the paper handy, but a KB article states that
LastUpdated does not function in Access 2000 because of
changes made when Access Projects were introduced. For
some reason, the Jet engine no longer reports this
information to Access. Apparently there is also no way of
extracting it from the database window. I assume this is
an oversight and not a deliberate design change. One would
think there would be a patch, since it is a known issue.
If it has been fixed in Access XP or 2003, this would be
enought to trigger an upgrade for us.