Is there a way to have a query pull all of the table names within a database and display the number of records in each table? The names, number of tables in the database, an number of records within each table will always be changing, which is why I wanted to use a Query to pull the information.

I have already tapped into the MSysObjects table to retrive the Table names (via a Query), I am however stumped on how I am going to display each tables record count. Any help would be appreciated. Thanks in advance.

Add a field:

HowMany: DCount("*",[name])