or U can query the table with sql like:<BR><BR>rs_counter is a 'fresh', empty recordset...<BR><BR>rs_counter.open "SELECT COUNT(*) FROM yourTable", yourConn<BR><BR>and get the record count in rs_counter(0)
RE: count(*) give total number of records in Table
1) Don't use Count(*). That forces a fullscan of all rows AND columns. Instead use Count(nameOfPrimaryKeyColumnInTable) if you chose to go with that method<BR><BR>2)Some cursortypes do not support the recordsetObject.Count because it requires the move forward through the recordset and then back to the first record.<BR><BR>3)ALL recordsets support:<BR>MyArray = myRecordSet.GetRows<BR>myRecordSet.Close<BR>Set myRecordSet = Nothing<BR>MyCount = UBound(MyArray , 2) + 1<BR><BR>This also has the advantage of letting you free up your resourses by killing the recordset object and displaying the information by stepping through the array.