By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 1,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Get the created date for a Table in MS Access

P: 3
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.
Sep 10 '07 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
Do u want date of table creation or the date of last transaction on the table ?
Sep 10 '07 #2

P: 3
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.
Sep 10 '07 #3

QVeen72
Expert 100+
P: 1,445
Hi,

Try this :

Expand|Select|Wrap|Line Numbers
  1. CurrentDb.TableDefs("TableName").DateCreated
  2. CurrentDb.TableDefs("TableName").LastUpdated
  3.  
Regards
Veena
Sep 11 '07 #4

P: 3
Hi,

Try this :

Expand|Select|Wrap|Line Numbers
  1. CurrentDb.TableDefs("TableName").DateCreated
  2. CurrentDb.TableDefs("TableName").LastUpdated
  3.  
Regards
Veena
Thank you very much!
Sep 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.