Multiple Access to Query tables

[woodyinoz]

Hi all,

I am in the process of developing a multi-user system but am experiencing a problem in allowing a table to be accessed by multiple users.
The problem arises when dealing with a queried table because each time the user opens a form the table is run to update the table. Obviously, if someone is already in the system and another user tries to enter the form they would get the following error -

<Table Name> is already in use

Has anyone got any ideas how I could get around this problem?

 

[Langley]

ok, let's see if I have this right. You open the form and a query generates an answer table that is then used to update the table that is being used by someone else? Are you using add()? Let's see the actual code for the update and maybe we can get an idea or two.

Mac

&quot;Do not delve too deeply in the arts of your enemy and so become ensnared by them&quot;

langley_mckelvy@cd4.co.harris.tx.us