title: Open recordset with OBDC tables, dbSeeChanges not working
body: <p>I have been struggling all day with running a loop through a recordset in MS Access 2010. I've been able to do this before, but never when the recordset is referencing the primary key. I've resolved the dbSeeChanges error, but it's still not working. Thanks for any advice, and happy Thanksgiving!</p>
  
  <pre><code>Private Sub Command26_Click()
  
      Dim Query As String
      Dim db As Database
      Dim rs As Recordset
      Dim url1 As String
      Dim url3 As String
      Dim fullurl As String
  
      url1 = "http://arlenmusic.azurewebsites.net/access-event-musicians.php?
      event_musician_id="
      url3 = "&amp;action=add"
      Query = "SELECT dbo_event_musician.job_number, 
      dbo_event_musician.event_musician_id, dbo_event_musician.sub_event_id, 
      dbo_event_musician.name, dbo_event_musician.instrument_key, 
      dbo_event_musician.set_up_time, dbo_event_musician.start_time, 
      dbo_event_musician.booked_until, dbo_event_musician.special_songs, 
      dbo_event_musician.attire, dbo_event_musician.include_status, 
      dbo_event_musician.sub, dbo_event_musician.status, dbo_event_musician.notes, 
      dbo_event_musician.date_entered from dbo_event_musician WHERE   
      (((dbo_event_musician.sub_event_id) Like [Forms]![event_scheduling]!
      [sub_event_selector])) ORDER BY dbo_event_musician.instrument_key;"
  
      Set db = CurrentDb
      Set rs = db.OpenRecordset(Query, , dbSeeChanges)
      Do Until rs.EOF
          fullurl = url1 + rs!event_musician_id + url3    
          Application.FollowHyperlink (fullurl)         
          rs.MoveNext     
      Loop     
  
      rs.Close
      Set rs = Nothing 
      Set db = Nothing    
  
  End Sub
  </code></pre>