can some one help me with the CursorType

i try to use

Connect.Open "DSN=vault; uid=colu; pwd=colu;"

strSQL = "select CusId,CusName from Customer ORDER BY CusName"

rstdpt.Open strSQL, connect, 3, 1, 1

now some times this code works and some time

PrintRec.Open strsql, connect, 3,3

this works

some times when i use adOpenStatic instead of 3 works some times it doesnt

can some one guide me

If PrintRec.Open strsql, connect, 3,3 works why not just use that?

I presume you included adovbs.inc ?

You need that file to use the named ADO constants

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.