Find tables without records 1

[Bennie47250]

I have inherited a database and in the database, there are over 200 tables. To learn how this database works, I am opening the tables to look at the fields and data. I am finding that most of the tables are empty. Is there a way I can find the number of records that are in a table without actually opening a table or running a query? My hope is that there is a system table/file that keeps up with this sort of thing.

Thanks
Bennie

 

[dhookom]

You have to run some type of query or code to get record counts. A simple, undocumented method is to use

SELECT msysobjects.Name, msysobjects.Type, DCount("*",[Name]) AS Expr1
FROM msysobjects
WHERE msysobjects.Name Not Like "msys*" AND msysobjects.Type=1;

Duane
Hook'D on Access
MS Access MVP

 

[Bennie47250]

Awesome!! That is just what I'm looking for. Thanks