title: MS Access Error 3622 vba
body: <p>I have an Access 2010 database that was local and I have since linked to a SQL 2012 database.  However, I have a form to insert a highlight record that runs the below code:</p>
  
  <pre><code>Private Sub Command18_Click()
  Dim R As Recordset
  Set R = CurrentDb.OpenRecordset("SELECT * FROM [tblJobHead]")
  R.AddNew
  R![Rep Num] = [Forms]![frmMain]![NavigationSubform].[Form]![RepNum]
  R![Item Number] = Me.ItemNumber.Value
  R![Description] = Me.Desc.Value
  R![EmpID] = [TempVars]![EmpID]
  R![Status] = 2
  R.Update
  R.Close
  Set R = Nothing
  DoCmd.Save
  End Sub
  </code></pre>
  
  <p>However, when I click the button I now receive the error:</p>
  
  <p>Error 3622 - You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column</p>
  
  <p>Any ideas?</p>
  
  <p>Regards,</p>
  
  <p>Michael</p>