|
-
Nov 26th, 2004, 09:09 AM
#1
Thread Starter
Fanatic Member
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.
-
Nov 26th, 2004, 09:17 AM
#2
try searching 'refreshcache' on google.
I think its a jetengine property. (JRO) but I dunno if its a method in Access 97 somewhere.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Nov 26th, 2004, 03:26 PM
#3
Thread Starter
Fanatic Member
Thank you, this is working now!
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
|
Reply With Quote