I am using an access front end to add a record to a Sql Server table using a variation of the code below. The record is not added and the following error is returned:
Error 3622: You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.
What do I need to change to make this work please?
With CurrentDb.OpenRecordset("SELECT * FROM dbo_TimeSheets WHERE 1=2", 2, 8)
!TPID = Me.TPID
!EmployeeID = Me.EmployeeID
!Labor_Date = Me.Labor_Date
!No_Of_Hours = Me.No_Of_Hours
!Labor_Code = Me.Labor_Code