There still should not be a problem with the connection that queries that data. I think we should be looking at this from the angle of how the records are being added to the database. If you issue from the command window:

? SQLGETPROP(nHandle, 'Transactions')

It should be 1. If it is 2, then you have to handle the COMMIT of the data manually with a SQLCOMMIT() or SQLROLLBACK(). How are you handling the addition of new records? Are you doing this testing using 2 different connections, from 2 machines or 2 instances of VFP?