Access/SQL - Update records

[ProcessMgr]

I have an Access2003 database that we are converting the backend tables to SQL Server Express. Since this is one of my first times dealing with SQL Server Express, I am having a few issues with one of the programs. Basically it takes a temporary file created in the Access database and it needs to update two tables in the SQL database. I have part of the code below - the temporary file is tblRegister. If there is another way I need to do it, please let me know. Also if anyone has a code example of how I should open the tables and loop thru them - update and exit, that would be great. Thanks.

Private Sub cmdPost_Click()
Dim db, ldb As Database
Dim rstR, rstC, rstT As Recordset
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Dim Lst As ListBox
Dim strFill As String
Set Lst = Me![lstMCNumbers]
Style = vbYesNo ' Define buttons.
Title = "Post registry"  ' Define title.
Help = ""   ' Define Help file.
Ctxt = 1000 ' Define topic
        ' context.
        ' Display message.
Response = MsgBox("Post Registry into Customer list?", Style, Title)
If Response = vbYes Then
Set db = CurrentDb()
'Set db = OpenDatabase("n:\TestData\PascoData_041107.mdb")
Set ldb = CurrentDb()
Set rstR = ldb.OpenRecordset("tblRegister")
'Set rstC = db.OpenRecordset("tblCustomers", dbOpenSnapshot, dbSeeChanges)
''Set rstT = db.OpenRecordset("tblTransactions", dbOpenSnapshot, dbSeeChanges)
 
'rstR.MoveFirst  'take out
Do While Not rstR.EOF
   rstC.FindFirst = "MCNumber=" & rstR.MCNumber '<if MCNumber is numeric
 
 ' rstC.Index = "MCNumber"  'take out
 ' rstC.Seek "=", rstR.MCNumber 'take out
  If rstR![PostIt] = True Then
    If rstC.NoMatch Then
      rstC.AddNew
      rstC![MCNumber] = rstR![MCNumber]
      rstC![DOTNumber] = rstR![MCNumber]  ''03/27/07 added by DRA for DOT#

[nico5038]

Hmm, taking the hard way...

I would create unique indexes on the SQL Server tables and use an INSERT query in Access to add the not existing rows.
As the Unique index will prevent duplicates to be inserted, this is a safe (and fast) way to add new rows into a table.

Getting the idea ?

Nic;o)