Results 1 to 3 of 3

Thread: MDB problem [RESOLVED]

Threaded View

  1. Nov 26th, 2004, 09:09 AM #1
    Gensor
    Gensor is offline

    Thread Starter
    Fanatic Member
    Join Date
    May 2004
    Location
    Granby, Qc, Canada
    Posts
    602

    MDB problem [RESOLVED]

    I have 2 programs, one is saving values in an Access DB and the other program is reading values in the same Access DB with a timer.

    I tried putting 2 connections in the same app, it tooks the same time for both the read the values if I do this :

    myConnection.BeginTrans

    myConnection.Execute("INSERT INTO...

    myConnection.CommitTrans

    But if the 2 connections are in different program, it takes 2-3 seconds for the connection that didn't write the values to read it!

    It needs to be about half a second! 2-3 seconds is way too long!
    Last edited by Gensor; Nov 26th, 2004 at 03:27 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width