Results 1 to 4 of 4

Thread: access help

  1. #1
    Join Date
    Oct 2003
    Location
    uk
    Posts
    12

    Unanswered: access help

    hi, does anyone know much about the functionality of access xp, if so could you please tell me where transaction processing comes into it?cheers

  2. #2
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91

    Re: access help

    Originally posted by mercer876
    hi, does anyone know much about the functionality of access xp, if so could you please tell me where transaction processing comes into it?cheers
    Hi ! When u say "transaction processing" do u mean features like Begin Transaction, Roll Back and so on ?
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  3. #3
    Join Date
    Oct 2003
    Location
    uk
    Posts
    12

    Re: access help

    Originally posted by Mixirica
    Hi ! When u say "transaction processing" do u mean features like Begin Transaction, Roll Back and so on ?
    yes in that context yes

  4. #4
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91

    Re: access help

    Originally posted by mercer876
    yes in that context yes
    Maybe this peace of code helps u:

    Code:
    Dim cnn As ADODB.Connection
    Dim rst As ADODB.Recordset
    Dim blnIsTrans As Boolean
    
    On Error GoTo Tratamento
    
    Set cnn = CurrentProject.Connection
    cnn.BeginTrans
    blnIsTrans = True
    .
    .... here u put your instructions: Appends, updates, etc.
    .
    .
    .
    cnn.CommitTrans
    blnIsTrans = False
    
    Exit Sub
    
    Tratamento:
    
    'If an error occurs ...
    
    If blnIsTrans = True Then
        cnn.RollbackTrans
    End If
    MsgBox Err.Description
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •