Multiple connections on Access 97

[ravindra joshi]

we use two Visual Basic 6.0 applications to access a
common Microsoft Access 97 database. One application
inserts some records in Access table. These cannot be seen
on quering from other application if queried immediately.
It takes some time , approximately 4 - 5 seconds to
display expected results. Commit has also been tried. AS
Access is suppose to be RDBMS, committed transactions
should have been reflected immediately.

 

[TC]

Are you sure the delay is not at the VB end? How do you know that it is at
the Access end?

Also, you are actually using Jet - not Access. Access is just the user
interface (forms, reports etc). The underlying RBDMS, is Jet.

HTH,
TC