Access database DAO Transacation

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • umangrdesai@gmail.com

    Access database DAO Transacation

    Hi All,
    I am using DAO transacation in my code and everything is running
    perfectly alrite. but it is not commiting my transacation. and whole
    code is running without any errors.At the end of code its commiting
    transacation but there is no effect on database.
    Can any one please guide me what can be the cause of this or is there
    any limit on DAO transacation.?

    Please help me.

    Thanks
    Umang.
  • Keith Wilby

    #2
    Re: Access database DAO Transacation

    <umangrdesai@gm ail.comwrote in message
    news:cbc5bf27-a830-4921-b8b8-eac3aa57da7d@e5 3g2000hsa.googl egroups.com...
    Hi All,
    I am using DAO transacation in my code and everything is running
    perfectly alrite. but it is not commiting my transacation. and whole
    code is running without any errors.At the end of code its commiting
    transacation but there is no effect on database.
    Can any one please guide me what can be the cause of this or is there
    any limit on DAO transacation.?
    >
    Post your code.

    Comment

    • Salad

      #3
      Re: Access database DAO Transacation

      umangrdesai@gma il.com wrote:
      Hi All,
      I am using DAO transacation in my code and everything is running
      perfectly alrite. but it is not commiting my transacation. and whole
      code is running without any errors.At the end of code its commiting
      transacation but there is no effect on database.
      Can any one please guide me what can be the cause of this or is there
      any limit on DAO transacation.?
      >
      Please help me.
      >
      Thanks
      Umang.
      Are you using .Addnew? If so, after assigning the data to the
      respective fields to an .Update.

      Beautiful Girl

      Comment

      Working...