Moving to the last record in a recordset.

I have the following code in my app :

*************************************************************
Set db = New Connection
db.CursorLocation = adUseClient
' db.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Developers\SCR Database\SCRsystem.mdb;"
db.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SCR System\SCRsystem.mdb;"


' Open employee table.
Set adoprimaryrs = New Recordset
adoprimaryrs.open "select * from [SCR List]", db, adOpenStatic, adLockOptimistic
adoprimaryrs.MoveLast
*************************************************************
For some reason, the last record in this collection is not the last record in the database (if I check it manually).

Anybody know why this would be so ?

You could try setting your connection to an ADODB.connection and your recordset to an ADODB.recordset. That ensures that the ado methods work properly.

Eva

OK done that.

Still get same response. The recordcount tells me 281, which is correct, but when I try a ".movelast" and then display a field from the record, it is from a record roughly 2/3 of the way through the collection !!!

There are no filters on my SQL statement, as you can see above, so I'm a bit stumped on this one.