Value for adCmdUnknown

[Bresart]

Hi, i have the code:

Dim rst As Object 'ADODB.Recordset
Set rst = CreateObject("ADODB.Recordset")

rst.Open strQuery, CurrentProject.Connection, _
adOpenStatic, , adCmdUnknown


For avoiding errors the adXXX constants must be replaced by its true value, 3 for adOpenStatic, but which for adCmdUnknown?

Thanks for any help given.

 

[CautionMP]

8

Object Browser?

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[Bresart]

Thanks CautionMP.

I don't understand your question, can you explain it more?

 

[JoeAtWork]

In a project that has a reference to ADO, you could type in the Immediate window

?adCmdUnknown

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[Bresart]

Thanks JoeAtWork.