🚀 go-pugleaf

Hi,
    Forget the last message.
    Access doesn't support nested transactions. It supports one transaction
per session at one time. One record can NOT be locked by two transactions at
the
same time. I guess you are right. So you have to start a transaction after
another transaction is done.

Yuancai (Charlie) Ye
See 26 OLEDB examples at http://www.geocities.com/oledbpro

"Cristian" <cgv@diit.cl> wrote in message news:3a75d123_2@dnews...
> Hi:
>     Thanks, but the problem is: how can I make changes during a
transaction
> in a table that is accessing by another transaction? I'm working in a MDI
> project, and the Child window have an ADOConnection component. This
> connection component open an access table and start a transaction. The
first
> child window I open present no trouble, then I open another child windown
> (the first still open); the BeginTrans method start without erros, but
when
> I try to post a record a message error pop up: currntly record locked...
>
> What can I do to unlock the record???
>
> When I use Paradox table the solution is TSession component, but in ADO
> isn't exist a similar component to TSession. Maybe the problem is that
> Access can't accept multiple transaction executing at the same time
> accessing the same table, what do you think?
>
> Yuancai (Charlie) Ye <yekerui@yahoo.com> escribi� en el mensaje de
noticias
> 3a75c3e8$1_2@dnews...
> > Hi,
> >     I think you have to wait until other tranasctions are completed.
> >
> > Yuancai (Charlie) Ye
> > See 26 OLEDB examples at http://www.geocities.com/oledbpro
> >
> > "Cristian" <cgv@diit.cl> wrote in message news:3a757701_2@dnews...
> > > Hi:
> > >
> > > I'm using BeginTrans method  with ADOConnection component but records
> are
> > > lock to others transactions.
> > > How can I unlock records?
> > >
> > >
> > >
> >
> >
>
>