>Hi All
>
>A am now seeing a frequent problem that only happened once in a great while before.
>
>A payment is recorded on the system where it adds a record to a payment file and
>then updates one or more receivable file records for the customer. The code APPENDS
>a record to the payment file then SELECTS the receivable file and updates the records
>required.
>
>The payment file gets added to but SOMETIMES the receivable file does not get updated.
>
>I am seeing this on networks as well as stand alone installs.
>
>This code has been running for years with little problems.
>
>What am I missing. Should I be closing each file after update or what.
>
>Terry

Hi Terry,

It really helps if you post the code you're using.