Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement