title: How to use DAO recordset AddNew updating on split databases with links
body: <p>After creating a database, testing it, and confirming that all routines execute perfectly i run into problems with the DAO record set commands once i split the database and link the tables.  The following below is one (of many) DAO record "ADD NEW" commands that no longer function after the split.  Strangely, i found one workaround to this problem by deleting the linked table, and creating an identical local table in the front end where the record is then updated correctly but for my needs, this workaround will not be acceptable for there are too many tables which i need to contain in the back end database for security purposes.  </p>
  
  <pre><code>Dim rst As DAO.Recordset
  Set rst = CurrentDb.OpenRecordset("tblHoldingProjectDeepDive01", dbOpenTable)
  rst.AddNew
  rst!ID_Project_Sub_Phase = Me.IDProjSubPhase
  rst.Update
  rst.Close
  Set rst = Nothing
  </code></pre>