dbSeeChanges specified in OpenRecordset yet Access still raises error 3622

D

Douglas J. Steele

I know that in some cases, parameters are ignored after the first missing
one is encountered. See whether that's the case here.

Try:

Set rstDrawings = CurrentDb.OpenRecordset(SQL, dbOpenForwardOnly,
dbSeeChanges)

or

Set rstDrawings = CurrentDb.OpenRecordset(name:=SQL, Options:=dbSeeChanges)
 
I

Ivan Starr

Hello thank you for trying to help.

I have a call to OpenRecordset with an SQL query that references linked
tables that are linked to tables on an SQL Server. The call gets error 3622
(You must use the dbSeeChanges option with OpenRecordset when accessing a
SQL Server table that has an IDENTITY column)

Here is the code:

Dim SQL As String
....
SQL = "SELECT dbo_Drawings.LoringsSubmittalNumber,
dbo_Drawings.TrackingNumber, dbo_Drawings.TransmittalNumber,
dbo_Transmittals.DateSent " _
+ " FROM dbo_Transmittals INNER JOIN dbo_Drawings ON
dbo_Transmittals.ID = dbo_Drawings.TransmittalNumber WHERE
(((dbo_Drawings.LoringsSubmittalNumber) = '" _
+ SubmittalNumber + "') And ((dbo_Drawings.JN) = " + JN _
+ ")) ORDER BY dbo_Transmittals.DateSent;"
Set rstDrawings = CurrentDb.OpenRecordset(SQL, , dbSeeChanges)

Anyone have any idea why? Thanks for trying.

Ivan
 
Top