DAO Object
 
Returns the total number of records in a TableDef object. Read-only Long.
 

Syntax

expression .RecordCount
expression A variable that represents a TableDef object.
 

Remarks

Recordset or TableDef object with no records has a RecordCount property setting of 0.
 
When you work with linkedTableDef objects, the RecordCount property setting is always –1.