I have previously got this error if I open a recordset and make updates, and
then call begintrans. The reason being, I think is, how does ADO know
whether those changes are in the transaction or not? Cheers,

Mark

-----Original Message-----
From: Harshang Pandya [mailto:harshangp@y...]
Sent: 29 January 2002 23:03
To: professional vb
Subject: [pro_vb] Re: ADODB error


No, I don't have any update statement before
begintrans. But I do use connection to open readonly
recordset to view record before updation.


--- David Adams <davidadams00@h...> wrote:
> How are you handling the updates?
>
> "Attribute cannot be set now" - have you already
> performed the Update (like
> Cn.Execute "<Some SQL Update Statement>" before it
> attempts to set the
> CommitTrans?
>
> David Adams
>
> ----- Original Message -----
> From: "Harshang Pandya" <harshangp@y...>
> To: "professional vb" <pro_vb@p...>
> Sent: Tuesday, January 29, 2002 4:56 PM
> Subject: [pro_vb] ADODB error
>
>
> > I am using ADODB to add data in two tables. I use
> > BeginTrans and CommitTrans to make sure data added
> in
> > two tables. I am getting following error on
> BeginTrans
> >
> > Error Number -2147467259
> > Error Desc [Microsoft][ODBC Microsoft Access
> > Driver]Attribute cannot be set now
> >
> > Let me know if you have any solution...
> >
> > I am using same connection to view/add records..
> >
> > Thanks,
> > Harshang
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Great stuff seeking new owners in Yahoo! Auctions!
> > http://auctions.yahoo.com
> >
> $subst('Email.Unsub').
> >
>
$subst('Email.Unsub').


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com