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 ?