dbSeeChanges error with IDENTITY column

[gmazza via AccessMonster.com]

Hey there,
I am getting an error on this line that says I need a dbSeeChanges with
IDENTITY column

Set rst = CurrentDb.OpenRecordset("dbo_ErrorLog", , dbAppendOnly)
Where do I add it? I have been reading the forums and trying different things
out and I am still getting this error.

I set up an errorlog routine and my database errored so it went to the
routine and crapped out on that line.

Thanks!!

 

[Dirk Goldgar]

Hey there,
I am getting an error on this line that says I need a dbSeeChanges with
IDENTITY column

Set rst = CurrentDb.OpenRecordset("dbo_ErrorLog", , dbAppendOnly)
Where do I add it? I have been reading the forums and trying different
things
out and I am still getting this error.

I would expect you to include that option like this:

Set rst = CurrentDb.OpenRecordset("dbo_ErrorLog", , _
dbAppendOnly + dbSeeChanges)

 

[gmazza via AccessMonster.com]

Thank you sir, it worked!

Hey there,
I am getting an error on this line that says I need a dbSeeChanges with

[quoted text clipped - 4 lines]

things
out and I am still getting this error.

I would expect you to include that option like this:

Set rst = CurrentDb.OpenRecordset("dbo_ErrorLog", , _
dbAppendOnly + dbSeeChanges)