Querying to get Access Statistics

[ErikRP]

This is either very simple or very complex, I haven't figured out which yet.

I need to know the number of tables in my database and from each table I need to know how many records are in each table. Ordinarily I would just count the number of tables then open each one up to get the number of records, but I'm working with 100+ tables so that's not very practical.

If it makes a difference, the tables in question are linked tables. I don't imagine that is relevant, but thought I'd mention it.

Thanks!

 

[pbaldy]

Poke around here for TableDef and you'll find the code to loop through all the tables. Within that loop open a recordset to get the count for the current table. Add debug.print to print out the name and count (or save to a table if that's your goal).

 

[ErikRP]

Thanks! I'll have a look and see what I can find.