Re: Transactions in Access

But ADO transactions are at Connection-level.

Dim cn As ADODB.Connection
'- - - -
cn.BeginTrans
'- - - -
cn.CommitTrans

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OFqnkY5PFHA.3628@xxxxxxxxxxxxxxxxxxxxxxx
> The SQLTransaction class are for the .NET framework and ADO.NET. ADO and
> ADO.NET are two very different things and cannot be mixed.
>
> ADO transactions are supported under Access if you are using ADO objects.
> You can use the first workspace of the DBEngine to work with transaction
> in exactly the same way as with DAO. However, for bound forms, mixing
> your own transactions with the transactions created by Access for the
> bound form is a recipe for a disaster.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
>
>
> "Walter Levine" <wlevine@xxxxxxxxxx> wrote in message
> news:Ok4K9o4PFHA.3760@xxxxxxxxxxxxxxxxxxxxxxx
>> Are ADO transactions supported in Access?
>> the thing I cannot do is to create an SQL Transaction object i.e.
>> Dim myTran as SQLTranaction
>> there seems to be no such thing
>> Cans someone point me to documentation that explains how to do it?
>> thanks
>>
>>
>
>


.

Relevant Pages

  • Re: Transactions in Access
    ... The SQLTransaction class are for the .NET framework and ADO.NET. ... ADO transactions are supported under Access if you are using ADO objects. ... transactions with the transactions created by Access for the bound form is a ...
    (microsoft.public.access.adp.sqlserver)
  • Transactions in VB6 using MSDE 2000
    ... When the program used Access I had set up several ADO transactions ... Since upgrading to MSDE I am having strange things happen ... What is different in MSDE regarding transactions from ADO ...
    (microsoft.public.data.ado)
  • ADO transaction problems since upgrading from Access2K to MSDE 2K RelA in VB6
    ... When the program used Access I had set up several ADO transactions ... Since upgrading to MSDE I am having strange things happen ... What is different in MSDE regarding transactions from ADO ...
    (microsoft.public.sqlserver.msde)
  • RE: Help Please!
    ... You can limit a query, report, or form to a specific date range by using a ... Microsoft Access MVP ... they still show as individual transactions. ... Every transaction has a client, of which, I have over 40. ...
    (microsoft.public.access.reports)
  • RE: Transfer from one table to another table for histrory file
    ... Transactions are not supported for Linked Tables. ... Dave Hargis, Microsoft Access MVP ... "tedmi" wrote: ... So if you are using the Jet datastore, I suggest you leave the records in ...
    (microsoft.public.access.modulesdaovba)