pulling table modified date

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

hey all, i'm trying to set the value of a text box on my form to the Created
Date of a table in my database. its not the recordsource of the form. any
ideas?

TIA
Ted
 
You could get the creation date of the table if you OpenDatabase on the back
end, and look at the DateCreated property of the TableDef:
OpenDatabase("C:\MyFolder\MyDB.mdb").TableDefs("MyTable").DateCreated

Unfortunately, Access 2000 and onwards doesn't maintain these dates
correctly for all objects, so test it thoroughly.
 
Thank you Allen, I tried code similar and also tried yours and i keep
getting "Invalid use of property". It doesn't like the DateCreated Property.
any ideas?
 
ummmm one more thing...i have a link to the table in my db. i tried using
the dlookup function but it gives me the date created of the link

DLookup("DateCreate", "MSysObjects", "Name =
'L:\TVB\DIGINV\DIGINV.MDB\ALLCOMPANIESDATA'")
 
Take it a step at a time.

Try:
OpenDatabase("C:\MyFolder\MyDB.mdb").Name

Then:
OpenDatabase("C:\MyFolder\MyDB.mdb").TableDefs("MyTable").Name
and so on.
 
Thx Allen...i tried that but still got "Invalid use of property"
is there a reference that i'm missing?
 
Back
Top