I have a data entry form in a multi-user LAN application experiencing slow tableupdate()'s. The tables involved use buffering mode 5. The slowdown becomes noticable when a third person runs the same form.

Our company maintains structurally identical databases for separate clients, each in their own folder on a network server. There is a shared area, with various lookup tables used by all clients. This form is for entering property values from a paper notice of value.

Form process is as follows:

1. The user enters some identifying info. ( property tax parcel numbers, mostly)
2. A fairly complex search happens to match the acct number to a record in a shared lookup table. If a match is not found, user is notified, and the form resets itself for further searching.

3. If a match is made, they enter the desired data values in a few form variables. The save method then determines which client data set to save results to, opens the appropriate tables and makes the updates.

tableupdates are enclosed in a transaction.