Don't rely on FireDAC or any of the database-related components to get you a record count. Go straight to SQL and ask for the total record count with a direct statement:

TotalRec := Connection1.ExecSQLScalar('SELECT count(*) from YourTableName');