Question Record Locking Problems

[CharlesWhiteman]

On my main form exisits the customers address. The text boxes are locked to prevent users from accidentally deleting or changing information. I have a button which brings up an unbound form, uses DLookup's to fill corresponding edit boxes and then a save button with SQL Update strings to update the database with added/changed address data.

My main form does has 'no locks' set on the forms properties.

The form to update the data has 'Edited Record' set as a lock.

I have a search screen which has a list box of customers. A DblClick brings up the main form filtered to the requested record.

If I then choose to update the data, make a change and click save I get a record change warning to save/drop/copy changes. If I choose save or copy I get chinese looking characters replacing certain columns in the customers record but the affected columns are not any that are part of the fields edited.

If I choose drop then I get a runtime error 3270, I handle that, close the form and the changes are saved ok and no chinese characters.

Strangely though, if I choose to update the data again the record locking / write error and runtime error is not repeated.

 

[CharlesWhiteman]

Oh yeah, the database has been split.

 

[CharlesWhiteman]

If, when I open a record I unfilter the form and use the record navigator to go to another record the error does not occur