Get the created date for a Table in MS Access

[Redeemed1]

Can any one help me? I need to retrieve the created date of a given table in MS Access using VBA. (If the date = today's date then I will run my query, else I will have to wait until the table has been updated.) Thank you.

[debasisdas]

Do u want date of table creation or the date of last transaction on the table ?

[Redeemed1]

Do u want date of table creation or the date of last transaction on the table ?

I just need to know when the table was created. Thank you.

[QVeen72]

Hi,

Try this :

[code=vb]
CurrentDb.Table Defs("TableName ").DateCrea ted
CurrentDb.Table Defs("TableName ").LastUpda ted
[/code]

Regards
Veena

[Redeemed1]

Hi,

Try this :

[code=vb]
CurrentDb.Table Defs("TableName ").DateCrea ted
CurrentDb.Table Defs("TableName ").LastUpda ted
[/code]

Regards
Veena

Thank you very much!