Peter J. Boettcher — Thu, 26 Apr 2001 17:50:19 +0000

That file is only necessary when you want to refer to the properties by name (adOpenDynamic) instead of the number (1,2,3, etc). That should not have any effect on whether or not .RecordCount works unless you hade some sort or error checking on (On Error Resume Next).

Instead of including that file (adovbs.inc) I just make reference to the actual ADO library on my server, I use this line in my global.asa:

Thanks

1aspfan — Thu, 26 Apr 2001 15:20:42 +0000

Thank you for your reply.

I tried changing the cursor and it produced the same results. When I entered this line of code it worked.

Is this necessary?

Thanks

Mike

Peter J. Boettcher — Wed, 25 Apr 2001 12:37:46 +0000

RecordCount depends on the type of cursor you use, and where you open it (client or server). If I remember correctly all client side cursors support RecordSet, and server-side Dynamic & Forward only don't. So I'm guessing you're either not specifying the cursor or you're using one of these 2 server-side ones. Try changing your cursor.