Right now I don't find if the data is already there so I get an error because one of the fields is a key field.
Set rs = db.OpenRecordset("PROGRAMTABLE", dbOpenDynaset)
rs.FindFirst "ID='" & ProgID& "'"
If rs.NoMatch Then
rs("ID") = ProgID
rs("title") = ProgramTitle
rs("desc") = ProgramDescription
This method is SUPER SLOW. I'm not sure what makes it slow. It seems to work.
If I don't use the dbOpenDynaset option.
And just do an update (the no match and find first statements commented out) then the database update is super quick. The problem is if the data already exists because of a previous update then I get an error.