I am developing an Access application using Access 2010 running under Windows 7. The database has some large tables containing many thousands of rows. I want to display the number of rows in these tables in a form.
I have tried a couple of methods to do this, both of which work fine except that they take several seconds to run. One method is to use DCount; the other method is to create a recordset and access its RecordCount property. I'd welcome any suggestions for a faster way to do this.
When I open a table interactively, the number of rows is immediately displayed. It seems that Access keeps track of the number of rows in a table and that there is probably a way to access that number without writing code to rediscover it. I've hunted, without success, to access this number.
Gordon