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!

try searching 'refreshcache' on google.

I think its a jetengine property. (JRO) but I dunno if its a method in Access 97 somewhere.

Thank you, this is working now!