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

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200912/1

"gmazza via AccessMonster.com" <u37142@uwe> wrote in message 
news:a1551118aeae2@uwe...
> 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)


-- 
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Thank you sir, it worked!

Dirk Goldgar wrote:
>> 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)
>

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200912/1