Try as I might, I can not get the MaxRecords property to work.

I am on a Win 2000 machine with Access 2000.
I am using ADO 2.5

I have tried to create a system DSN with the Access database and set a cn to that but when I do rs.MaxRecords = 2...it just ignores it.

I've also tried doing

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False"
and then doing rs.MaxRecords = 2 and it still ignores it.

Can someone tell me the secret on getting this to work properly??
THanks