By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Multiple Users Running Same Query

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.