dbSeeChanges Error with SQL Back End

[CPGDeveloper]

Hi All~

I'm trying to create a recordset in VBA using a SQL linked table and am getting Error 3622 - "You must use dbChanges with the OpenRecordset...."

I tried to add that option but it seems to not make a difference. I have something like this --

Dim usql as string
Dim urs as DAO.Recordset

usql = "SELECT * FROM tbl1 WHERE tbl1.ID = 1;"
Set urs = CurrentDb.OpenRecordset(usql, , dbSeeChanges)

With or without the dbSeeChanges I'm still getting the error -- any help would be greatly appreciated. Thanks!

 

[RoryA]

Does it help if you use:

Set urs = CurrentDb.OpenRecordset(usql, dbOpenDynaset, dbSeeChanges)

 

[CPGDeveloper]

You are a genius sir. That worked. Thanks!

 

[RoryA]

Glad to help.