OpenRecordset Question 1

[jasonphillipstx]

The following line works

Set rst = db.OpenRecordset("visitorreportrecipients", , dbSeeChanges)

the following line gives me an error stating that I need to use the dbSeeChanges option for a table on SQL server that has an identity.

Set rst = db.OpenRecordset("select * from visitorreportrecipients;", , dbSeeChanges)

I need to use the one with the sql statement. I have tried every which way to no avail. Any help is appreciated.

 

[PaulBricker]

Are you opening this against an SQL server backend? According to help, the dbSeeChanges only works with a Microsoft Jet dynaset type recordset so that may be the issue. You can try adding the type argument, dbOpenDynaset, and see if that helps. The default type is a table type when the argument is left blank.

Paul

 

[jasonphillipstx]

that did the trick thank you.