pass thru queries giving other users result while sorting- Pl help

[gdc]

Please help regarding this problem.

I have the database dentalprod.mdb in the server which can be accessed by 6
users. The application is designed like I will take the input from the user
thru form for ex city and state which I use to run the query( For ex
City_State_query note: all the queries in the application are pass thru
queries).

So when a user A enters the input as City "Des Moines" State "IA" then I am
getting the data pertaining to that city and state getting displayed in
datasheet view. User A had not closed the query in datasheet view. Now while
user A has kept the query open user B access the application from different
machine and runs the same query with the input as City "Chicago" State "IL"
so he is getting his data displayed in the datasheet view he keeps it open.
So now 2 users A and B had run the same query with different inputs and had
different data with A running it first and then user B, both had kept the
datasheet view open. Now when A sorts the data he has retrieved at first
with inputs as Desmoines IA, with one of the colums for exhone No what is
happening is user A is getting the data retrieved by user B that is with
input Chicago IL.

Please note that :We are not having any functionality added for sort but are
only using the sort option given by access in the query datasheet tool bar.



regards

gdc

 

[Douglas J. Steele]

Multiuser applications should be split into a front-end (containing the
queries, forms, reports, macros and modules) linked to a back-end
(containing the tables). Only the back-end should be on the server: each
user should have his/her own copy of the front-end, preferably on their hard
drive. Then you won't run into issues like this.