Need List of All Tables and a Record Count

[rdpress]

I have an Access 2000 mdb be and would like to create a table
that will contain a two field record (TableName and RecordCount) for each table in the mdb.

Any suggestions would be appreciated.

I've already created a table listing the names using a make query on MSysObjects.

thanks much

 

[dhookom]

This might not be the most efficient but you can create a query like:

SELECT msysobjects.Name, msysobjects.TYPE, DCount("*",[name]) AS RecCount
FROM msysobjects
WHERE (((msysobjects.Name) Not Like "Msys*") AND ((msysobjects.TYPE) In (1,4)));

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Duane, why not include TYPE=6 ?

 

[dhookom]

I didn't have any 6s in my database ;-)

Duane
Hook'D on Access
MS Access MVP