dbSeeChanges error with IDENTITY column

  • Thread starter gmazza via AccessMonster.com
  • Start date
G

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!!
 
D

Dirk Goldgar

gmazza via AccessMonster.com said:
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)
 
G

gmazza via AccessMonster.com

Thank you sir, it worked!

Dirk said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top