We are trying to figure out why all of a sudden we are getting table locks. The form which is trying to load uses all free table opened via code (not data environment). The open for the tables is located in the form LOAD procedure section. There has not been a change to this form in a long time and for the last few days, off and on, we will have one of two tables lock up. It locks it to where you even get attempting lock... if you try to open it from the command box as shared. Looking at open files with users on the network, it shows random users with only maybe two or three tables open, but the form should open about 10-15 (when running normal). When we clear their connection, it frees everyone else up again to use the table and hence the program. Any ideas as to what would cause this all of a sudden?
``` Appreciate a normal day, it is always better than a bad one ```
Kev