After Update Event Procedure not working after upsizing to sql server

[Zeeshan7]

After Update Event Procedure on a form is not working after upsizing database to SQL server. Anything to add in below code as it generate run time error 3622 "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column."

Please help.. thanks

 Private Sub Form_AfterUpdate()
     Dim db As Database

         Set db = CurrentDb
         db.Execute "INSERT INTO [tblFinding_Backup] " & " SELECT * FROM [tblFinding] WHERE " & " [tblFinding].[ID]=" & Me![ID] & ";"
         Set db = Nothing

     End Sub

[ChipR]

Haven't done this myself, but you may need to specify the columns to insert into. You might also be able to use SELECT INTO.

[Zeeshan7]

Need some more help to work around regarding error 3622 as stated above.

Thanks

[DonRayner]

After Update Event Procedure on a form is not working after upsizing database to SQL server. Anything to add in below code as it generate run time error 3622 "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column."

Please help.. thanks

 Private Sub Form_AfterUpdate()
     Dim db As Database

         Set db = CurrentDb
         db.Execute "INSERT INTO [tblFinding_Backup] " & " SELECT * FROM [tblFinding] WHERE " & " [tblFinding].[ID]=" & Me![ID] & ";"
         Set db = Nothing

     End Sub

Try line 5 like this

db.Execute "(INSERT INTO [tblFinding_Backup] " & " SELECT * FROM [tblFinding] WHERE " & " [tblFinding].[ID]=" & Me![ID] & ";"));, dbopendynaset, dbseechanges)"

[Zeeshan7]

Now it gives (Compile error: Syntax error)
Please advice. Thanks

[Zeeshan7]

I have used append query as an alternate.
Thanks