Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    29

    Unanswered: Library containing BeginTrans

    Hi!

    I developed a program in ACCESS and find that there is an ERROR, (ERROR Number 429) when executing a built-in function
    BeginTrans.

    I doubt if my computer is missing the library containing the BeginTrans.

    This code works fine if it is run in an environment with ACCESS 97 installed. Can I just put in the required library in the new environment without ACCESS 97 installed to make the programme runs fine.

    Thank you in Advance!

    regards,
    cchan

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    I think you need DAO so you will be able to do something like that


      Dim ws As Workspace
      Dim db As Database

       Set ws = DBEngine.Workspaces(0)
       Set db = CurrentDb()

       ws.BeginTrans
        db.Execute (Your SQL comes here )
        if yourCondition
         ws.CommitTrans
        else
         ws.Rollback
        endif

Posting Permissions

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