query error

[smk23]

I am getting an error on the following lines:

Set rs = New ADODB.Recordset
Set rs = .OpenRecordset(dbOpenSnapshot, dbSeeChanges)

When it tries to open the recordset, it claims that options are not set to
"dbSeeChanges" which looks to me like it's correctly set. The backend is SQL
server with an identity column (which requires dbSeeChanges). Any ideas?

Thanks!!

 

[Douglas J. Steele]

There is no OpenRecordset method in the DAO model.

What's your complete code (since the . in front of OpenRecordset implies
that that line is within a With construct)?

 

[Ofer]

Don't you mean in the ADO model?

 

[smk23]

That was it! I was mixing up ADO and DAO. It's DAO apparently that has the
openRecordset method. It's working when I changed to DAO.
Appreciate it!!

 

[Douglas J. Steele]

Yup, typo again.

Thanks, Ofer.