Opening two recordsets from the same table - both open simultaniously

[Anthony Jones]

Of course there is always the second connection solution.

Remind us, have you tested it with two connections? Did it work?

If it did but you still need to stick with just one connection then try:-

rs.moveLast
rs.moveFirst

on the first recordset before opening the second.

 

[Daniel Crichton]

Yes - same error.

Of course there is always the second connection solution.

I often use more than one recordset in a single ASP page all on a single
connection, both against Access and SQL Server.

Exactly which line do you get the error on? I've read through your other
posts and you don't appear to have pointed out the line causing it.

Also, what does your connection string look like? What provider are you
using? That wasn't in your code posting either.