I recently moved some of my tables into a SQL server, with a access front end, With this code the LogErrors (Allen Browne) is giving me a error code.
Initially it was error 3622 -"You must use the dbSeeChanges option with OpenRecords", so i added SDSeeChanges, and now getting error 3001 at the same line.
Any advise appreciated.
Initially it was error 3622 -"You must use the dbSeeChanges option with OpenRecords", so i added SDSeeChanges, and now getting error 3001 at the same line.
Any advise appreciated.
Code:
Set db = CurrentDb()
Set rst = db.OpenRecordset("tblQCLogError", dbSeeChanges)
rst.AddNew
rst![ErrNumber] = iErrNumber
rst![ErrDescription] = Left$(strErrDescription, 255)
rst![ErrDate] = Now
rst![CallingProc] = strCallingProc
rst![UserName] = GetLongName
rst![Parameters] = Job_ID
rst.Update
rst.Close