How to show all records for a table in ADP?

  • Thread starter aspfun via AccessMonster.com
  • Start date
A

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?
 
R

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
 
Top