Generating a query list with date created and date modified in Access

[hedgracer]

I need to generate a list of the queries that are in an Access 2003. This list must have the date the query was created and the date the query was last modified. Is there any way to do this through an access query? Thanks for all help in advance.

Dave

 

[dhookom]

You can try create a query based on the msysObjects table. I don't know if this is reliable since it isn't a documented functionality by MS:

SELECT msysObjects.Name, msysObjects.DateCreate, msysObjects.DateUpdate
FROM msysObjects
WHERE msysObjects.Type=5;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]