How to show all records for a table in ADP?

[aspfun via AccessMonster.com]

Once I open a table in ADP with the same table open in SQL server, total of
records is different. How to show all records for a table in ADP?

 

[Ray]

How are you comparing the number of records? When you open a recordset and
just look at the number of records, it will only show the number of records
it has actually fetched. To get an accurate number, you have to issue the
movelast command before checking recordcount.

Dim RS as recordset

rs.Openrecordset "Select * from Table"

I = rs.recordcount ' this gives the wrong answer
rs.movelast
I = rs.recordcount ' this gives the right answer

Ray