Table Record Counts from System Tables

  • Thread starter Thread starter Billy Rogers
  • Start date Start date
B

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/
 
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
 
Back
Top