General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a multi-user engineering drawing app. I am having some trouble with the app locking up. I seems to happen to just one of the tables. When a user begins to work on a particular drawing number the code first serches this table to see if the number exists. If it does the record is updated with current info. If the record does not exist I do an Insert Into command to add the record to the table. I have gone into the table manually while others were using the app and tried to append a record to the table. Sometimes the record will append fine. At other times I will get a message in the status bar 'Attempting to lock... Press ESC to cancel.' If I press cancel I get a message that record is in use by another user, which I do not see how that is possible. If I don't hit the ESC key and wait a while the record will somtimes go ahead and append, however the time it takes is much longer that the code would take for another user to add a record.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only