Steve Harp wrote:

>
> I have two applications that use the same database; applications A & B.
>
> If A is running with the database open and I run a process using B,
> the changes aren't seen by A until I close and reopen the database.

This is a special feature of databases called ACID transactions. One of
the ACID properties is Consistency, meaning that if A repeats the same
operation in the same transaction it gets the same results, regardless
of what B is doing.

Working with files, all you have to do is open and close them. With
databases, you open (connect) them, then start a transaction, work,
commit or roll back the transaction, then start another transaction, and
so on.

> What can I do in A to make sure that the changes made by B will be
> visible without having to close and open the database?
>

Commit and start a new transaction to see new data.

Regards,


Ann