dbSeeChanges

[carmenv323]

I have the following code which use dbSeeChanges but I'm still getting the error:
"Updating Data Error: 3622 You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column."

        
Dim sMReqs As String
sMReqs = "(select dbo_tbl_MultipleRequests.RequestID from dbo_tbl_MultipleRequests " & _
               " where dbo_tbl_MultipleRequests.[txtProjectNumber] = '" & Me.txtProjectNumber & "')"


      Set Records = db.OpenRecordset(sMReqs, , dbSeeChanges)
            If Records.RecordCount > 0 Then

[Welshgasman]

https://gunnarpeipman.com/you-must-u...entity-column/

or
https://www.access-programmers.co.uk...rver-t.293499/

[Gicu]

It would help if you show us the entire code including the declarations. What happens if you try this:

Dim db as DAO.Database  
Dim Records as DAO.Recordset
Dim sMReqs As String


Set db=CurrentDb
sMReqs = "Select dbo_tbl_MultipleRequests.RequestID from dbo_tbl_MultipleRequests " & _
               " where dbo_tbl_MultipleRequests.txtProjectNumber = '" & Me.txtProjectNumber & "'"


Set Records = db.OpenRecordset(sMReqs,dbOpenDynaset , dbSeeChanges)


If Records.RecordCount > 0 Then

Cheers,

[carmenv323]

Thank you, I figured out the issue was because I had RS as DAO.Recordset for all the queries in my code and changed it for this one, I don't know why. This worked and helped me move on

        Set RS = db.OpenRecordset(sMReqs, dbOpenDynaset, dbSeeChanges)
        


            If RS.RecordCount > 0 Then

Thank you for the clarification