dBASE for DOS Error 217:Lock Table is full.

How do I correct this error? I can't find any locked records or any references to the table in the manual. Where is the table and how can I either reset or repair the table?
Daniel7Asked:
Who is Participating?
 
cymbolicConnect With a Mentor Commented:
Generally, locking has to happen so quickly that it does not go through a table in your dbase app, but is provided as a server capability.  For instance, in many of the .dbf languages, records are locked by using the server locking capability, locking only one byte in a file per record, often at some virtual address many times larger than the actual record byte address, which allows a virtual lock by the development system/application, rather than an actual physical lock on the record.  Generally, running out of locks means that you have an application problem, or most likely, a network problem that is preventing what are usually very transitory locks to complete and become unlocked.  You won't find any physical locked records marked, but you should be able to use your server Administrative tools to see what items and tables are locked on the server when you get this problem, and diagnose/track down the source of the problem from there.

Generally, closing out the application(s) generating the locks will free them up and allow you to continue, but this only works reliably when your network is not having problems as well.

Look not unto your development system or your application for information on current locks, but to your server to find them.  Look to your application for potential coding problems/methods that lock up many records without unlocking, or to your network for communication problems that don't allow the locking process to release, or to a setting maximum locks allowed on your server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.