date created and modified

[Dona]

I need some help. I created some tables in Access 2003. I opened the files in Access 2007 and expected to see the date the table was created and modified last. What a surprise! I don't see any the details that Access 2003 had. Can you tell me where to find this information in 2007? Also, please give me any tips or helpful hints that used when converting to Access 2007.

Thank you in advance for your time!

 

[Galaxiom]

Show the System Tables in the Navigation Options. Right click on the Navigation bar.
The MSysObjects table holds this information.

They can be accessed via the properties of the object, DateCreated and DateModified.

 

[Dona]

Thank you very much!

 

[boblarson]

I wouldn't put too much stock in those dates. They don't always update the way you think they should and some of them update ALL of the same objects if you make a change. This is a known bug and the Access team is not going to fix it in 2007 if I remember correctly. I am not even sure that they were going to fix it in 2010.

 

[Dona]

Thank you for information.