title: Error 3622 Open SQL Server Table with Identity Column
body: <p>What am I doing wrong? I need to copy one record from the table dbo_customer (and then delete it there) to the table dbo_active_task. But I get an error "Error 3622 - You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column."</p>
  
  <pre><code>Dim stSQlIns As String
  Dim stSqlD As String
  Dim rs As DAO.Recordset
  
  If MsgBox("Copy № " &amp; Me![id].Value, vbYesNo + vbDefaultButton2, "Moving to the archive ") = vbYes Then
  
  stSQlIns = "INSERT INTO [dbo_new] " _
  &amp; "SELECT [dbo_customer].[id], [dbo_customer].[apartment], [dbo_customer].[description], [dbo_customer].[documents], [dbo_customer].[email], [dbo_customer].[first_name], [dbo_customer].[house_number], [dbo_customer].[last_name], [dbo_customer].[middle_name], [dbo_customer].[passport_number_str], [dbo_customer].[passport_number], [dbo_customer].[passport_series], [dbo_customer].[tel_number], [dbo_customer].[street_id], [dbo_active_task].[check_number], [dbo_active_task].[enable], [dbo_active_task].[production_datetime], [dbo_active_task].[production_method], [dbo_active_task].[shedule_datetime], [dbo_active_task].[shedule_end_datetime], [dbo_active_task].[task_desc], [dbo_active_task].[vip], [dbo_active_task].[customer_id], [dbo_active_task].[schedule_person_id], [dbo_active_task].[task_id]" _
  &amp; "FROM [dbo_customer], [dbo_active_task] " _
  &amp; "WHERE ((([dbo_customer].[id])=" &amp; Me![id].Value &amp; ")) "
  
  stSqlD = "DELETE [dbo_customer].*, [dbo_active_task].* " _
  &amp; "FROM [dbo_customer], [dbo_active_task] " _
  &amp; "WHERE ((([dbo_customer].[id])=" &amp; Me![id].Value &amp; "))"
  Set rs = Me.Recordset
  CurrentDb.Execute (stSQlIns)
  CurrentDb.Execute (stSqlD)
  Me![id].Requery
  
  End If
  </code></pre>