dbSeeChanges specified in OpenRecordset yet Access still raises error 3622

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
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)
 
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
 
Back
Top