🚀 go-pugleaf

Hi,
    Access doesn't support nested transactions. It supports one transaction
per session at one time. One record can 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?
> > >
> > >
> > >
> >
> >
>
>