Weird Access 97!!

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi all,

I have an Access 97 mdb that I'm opening with ADO 2.8 SP1 through a VB6
application.

ADO or the mdb itself behaves weirdly!!

When I say SELECT TOP 10 FROM mytable, it gets 5 records. When I say SELECT
* FROM mytable, it get's half of the records!!

Anyone every encountered this problem? Any solutions?

Thanks,
Ivan
 
Aarrghhh!!! I figured out what it is.

I have a loop similar to:
Do While Not myrst.EOF
stemp=myrst.Getstring(...)
myrst.MoveNext
Loop

I didn't know that GetString moves forward as well!!

Ivan
 
Back
Top