Multiple connections on Access 97

  • Thread starter Thread starter ravindra joshi
  • Start date Start date
R

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.
 
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
 
Back
Top