Thread: "File sharing lock count exceeded…"

In your append, update, or make table query (in other words, your action query, which will probably be an update query given your last thread), open in design view, then on the menu bar click view, then SQL view. Now, click on view again, and go to properties. You should get a menu with some options. Beside record locks, change the value using the drop down to "No Locks". In some versions of access it might be "Use transaction" in which the property would be no to avoid locks.