CursorType help

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

Newbie Poster

1 post since Jun 2004

Reputation Points: 10

Solved Threads: 0

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

Junior Poster

166 posts since Apr 2004

Reputation Points: 25

Solved Threads: 7

I presume you included adovbs.inc ?

You need that file to use the named ADO constants

Light Poster

32 posts since Jul 2004

Reputation Points: 10

Solved Threads: 1

This article has been dead for over three months

You