AFAIK, it's the last date that the structure of the table was
updated.
But for linked tables, it's not for the underlying table, but for
the table link. You could run it on the back end table:
DBEngine.OpenDatabase(Mid(CurrentDB.TableDefs("TableName").Connect,11
)).tableDefs("Inventory").LastUpdated
In code, you'd likely do that with:
Dim strDatabase As String
Dim db As DAO.Database
strDatabase = Mid(CurrentDB.TableDefs("TableName").Connect,11)
Set db = DBEngine.OpenDatabase(strDatabase)
Debug.print db.TableDefs("TableName").LastUpdated
db.Close
Set db = Nothing
And you could make that a function, of course:
Public Function GetBackEndTableProperty(strTableName As String, _
strProperty As String) As Variant
Dim strDatabase As String
Dim db As DAO.Database
strDatabase = Mid(CurrentDB.TableDefs(strTableName).Connect,11)
Set db = DBEngine.OpenDatabase(strDatabase)
GetBackEndTableProperty = db.TableDefs(strTableName)(strProperty)
db.Close
Set db = Nothing
End Function
Of course, you'd want to put in error handling in case the property
doesn't exist, but that's the basic structure.