I have used this type of code many times before, but its simply not working now for some odd reason I can't figure out. I am using Access 2003 with a SQL database. The error I get is ODBC --call failed 3146
Any help would be appreciated. Here is the code:
Code:Dim rsDxMg As Recordset Dim db As database Set db = CurrentDb Set rsDxMg = db.OpenRecordset("Select * FROM [Exam Info]", dbOpenDynaset, dbSeeChanges) With rsDxMg .AddNew !riop = "100" .Update End With