Append query hangs with multiple users

[Guest]

I am running an append query when opening a form in order to add records from
a linked SQL table to a table within Access. The Access table is then used
in the form to lookup individual records. This works fine when only one
person opens the form, however the query slows down when a second person
opens the form, and then basically comes to a halt as subsequent users try to
open it.

Any ideas?

 

[John W. Vinson]

I am running an append query when opening a form in order to add records from
a linked SQL table to a table within Access. The Access table is then used
in the form to lookup individual records. This works fine when only one
person opens the form, however the query slows down when a second person
opens the form, and then basically comes to a halt as subsequent users try to
open it.

Any ideas?

Split your application.

Each user should have their OWN copy of the frontend, a database with just the
forms, reports, code, and individual local tables; all should have links to
the SQL tables (and perhaps to an Access Backend if you have Access tables
separate from the SQL ones).

John W. Vinson [MVP]