hello,
quick suggestions, i haven't looked at your code yet but...
#1. you can either open the recordset using the Keyset cursor to obtain the recordset count, however, another more efficient way is to use the Count() function in you select statement.
#2. You need to use ( i think ) ADO 2.5 or greater for compadibitly with Access 2000
i'll take a look at your code, however it also looks like some others have downloaded, maybe they'll have some other suggestions for ya.
Regan
