I am using Delphi 7 and have two applications connected to same access database. The applications connect to access using ADO and JET
The first application inserts a record in the access database and the second application reads the database in a loop. In the begining of the loop I close and open the dataset to that any newly inserted records are picked up.
The problem I am facing is that when after the first application inserts one record, it is seen by the second application on the second loop which means that the dataset has closed and opened twice. The EOF property returns true the first time. Any ideas why it might happen?