dbSeeChanges Code

tucker61

Registered User.
Local time
Yesterday, 21:44
Joined
Jan 13, 2008
Messages
344
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.

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
 
What is error 3001?
 
How have you defined rst?
Error 3001 is very vague without the description text.
 
As Sonic says you don't have the syntax correct

Set rst = db.OpenRecordset("tblQCLogError", dbOpenDynaset , dbSeeChanges )
 

Users who are viewing this thread

Back
Top Bottom