Tamar,

I queried all records on SQL Server and the one record I inserted did not appear. It was definitely getting data from server because I put a marker in one of the fields. It is probably something simple but I cannot seem to ID the problem. It is able to locate any other record I converted. The inserted record looks the same and the key field, nFileNo, also looks the same as the others. A simple query in SSMS can find the inserted record BUT the FIND in my app cannot, just everything else???
Is it possible the new record is being protected when inserted in SQL Server? Not that familiar with SQL Server. This is my first conversion.

Bill