Would like to error sooner

[Steven]

First off I have to say that I was told my problem originates because I do
not have the database split and therefore multiple users a sharing the front
end.

The application is small and with 10 users who will not be accessing this
proceedure that often at one time and I would like to just make a quick fix.

So far my quick fix is when one user is in this particular form and another
user tries to open the same form I have an OnError trapping. This is ok but
it takes too long for the error to be recognized. Is this because the
database is trying a certain number of time before it errors out? How can I
make it error out faster if this is the case.

Thank you,

Steven

 

[Klatuu]

Forget the quick fix and do it correctly.
10 users, regarless of how often they use the application is too many. Two
users sharing the same front end is too many. You get errors like you are
getting, You have a very good chance (almost certain) of corruption. In
addition, it is much easier to modify and distribute your database when it is
split.

As to your question, no. There is no way. The performance issue is also
another side effect of a shared unsplit database.