| | |
|
|
|
dbSeeChanges specified in OpenRecordset yet Access still raises error 3622 |
|---|
| message from Ivan Starr on 13 May 2004 |
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
|
| Douglas J. Steele replied to Ivan Starr on 13 May 2004 |
I know that in some cases, parameters are ignored after the first missing
one is encountered. See whether that's the case here.
Set rstDrawings = CurrentDb.OpenRecordset(SQL, dbOpenForwardOnly,
dbSeeChanges)
or
Set rstDrawings = CurrentDb.OpenRecordset(name:=SQL, Options:=dbSeeChanges)
|
|
Archived message: dbSeeChanges specified in OpenRecordset yet Access still raises error 3622 (MS Access)
