Error with multiple users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that will be used by multiple users.

Each user will have their own form, which will be linked to a table on the
network. Every form will contain a record, which the user will edit. After
the user has edited the record, they will hit a button to go to the next
record. The code then searches for the next record in the table that is not
currently in use.

The error occurs when two users hit the button for the next record at the
same time.

Do you have any suggestions to solve for this error?

Let me know if I can provide any other information. Thanks.
 
It said action failed and then asks if I would like to halt. The action that
failed was running a macro that checks a box on the form called "In use".

I created this macro so that when a form in open or when a record is
retrieved from the table it will immediatey be be marked "In Use" on the
table that way no one else can retrieve that record or edit that record
because it is being edited.

I think the problem is that the lag between finding the next new record that
is not in use and checking "in use" is too long and therefore it causes an
error when two people are hitting the next button for another record.
 
Back
Top