Table Record Counts from System Tables

[Billy Rogers]

Is there a way to get table record counts from system tables in Access?

I can do this in SQL server and it's much faster that running a Count(*)
query on each table.


--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Douglas J. Steele]

I don't believe it's captured in the Access system tables.

 

[John Spencer]

Currentdb().TableDefs("MSysQueries").RecordCount returns 679 for one of my
databases

The RecordCount property only works with mdb and only with local tables. It
doesn't work with linked tables.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County