No locks available on UPDATE

This sometimes happens when you link a file into Microsoft Access and perform an update that affects a large number of rows.

Resolution:

If the number of records affected by an update is less than 8191, set the configuration options MAX_LOCKS and/or LOCKS_PER_FILE to a value slightly higher then the number of records. The maximum setting is 8191.

If the number of records is higher than 8191, set the TRANSACTIONS variable to FALSE. This causes the interface to ignore the transaction command and update the records individually.