Date & Time Stamp

[Maddd0ggg]

I update, import and export tables, problem is I need a way to track what I have done or allow someone to pick up where I left off. Is there a way for MS Access to return the Create or Modified Date and time stamp of any table?

 

[WayneRyan]

Mad,

Query the table MSysObjects. It will have an entry for your table and
its associated Create/Modify actions.

Wayne

 

[Maddd0ggg]

Ba-Da-Bing!

Thanks so very much... I can now also track if anyone messed up one of my queries too!!

 

[Cosmicnoodle]

sorry, this may sound really dumb - but how do you query the MSysObjects table?

Can you please give me an example...

 

[neileg]

sorry, this may sound really dumb - but how do you query the MSysObjects table?

Can you please give me an example...

System objects are usually hidden. Go to Tools\Options\View and check Show System Objects. The system tables can then be seen in the table tab and are available for queries.