Multiple Users Running Same Query

[Jeremy]

I have built a form that calls queries. I have the first 2 set up as
select queries, and the third set up as a make table query. When
multiple users are on this application at the same time, they get
errors or the data is overwritten while they are sitting there. If I
do all select queries, 1. the records pop up if I use a "RUN" command
button, or if I have my "Report" command button set to the last query
then each time they hit one of the three reports it re-runs the data,
which takes awhile. What are some options? I have heard about
append-delete queries, with the reports pulling the data that it needs
from the table, and then at some time deleting records. How and would
this work? What would be the most efficient way for multiple users to
be able to use this form at the same time, without having to re-run
the data everytime they wanted to look at one of the three reports
that show the data in different ways?

[Pieter Linden]

jc*******@rmhp.org (Jeremy) wrote in message news:<e9**************************@posting.google. com>...

I have built a form that calls queries. I have the first 2 set up as
select queries, and the third set up as a make table query. When
multiple users are on this application at the same time, they get
errors or the data is overwritten while they are sitting there. If I
do all select queries, 1. the records pop up if I use a "RUN" command
button, or if I have my "Report" command button set to the last query
then each time they hit one of the three reports it re-runs the data,
which takes awhile. What are some options? I have heard about
append-delete queries, with the reports pulling the data that it needs
from the table, and then at some time deleting records. How and would
this work? What would be the most efficient way for multiple users to
be able to use this form at the same time, without having to re-run
the data everytime they wanted to look at one of the three reports
that show the data in different ways?

split the database into front end and back end, distribute the front
to each user, and if you want to have a make-table query, put it in
the front end.