Trying to understand a split database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am splitting a database (tables on server, everything else on clients) and
trying to understand how it will work in the following scenario:

The database has 1 main table; it stores feedback organized according to
course. I am allowing a user to filter the table records from a main form
according to several criteria (date submitted, course name, type or topic of
feedback, and a couple others). Once the user implements that first filter,
he or she gets to review the filtered set in a subform.

Then, using a field in the table named "temporarySelect" (chkbox), he or she
can choose a subset of the first filtered set and review just those. (I
create the second filtered set by querying the query that provides the
recordset for the subform and setting the criteria for temporarySelect to
"true".)

My question: if two or more people are using the database simultaneously,
will the result sets be particular to the various users (so that user A will
not be running her second query off her own first query result set and not
that of user B)? Does the fact that the queries are not being run from the
server imply that the result sets they "create" are particular to the clients
running the queries?

Thanks
 
This depends on how you structure the front end of the database.

If the front end is distributed to each clients machine then you will
not have an issue as the temporary table will be constructed on their
individual copy of the front end .

If you have a common front end that all users are logging onto, that
temporary table will be common to that front end and you will run into
problems if more than 1 user attempts to create that temporary table.
 
Queries and form filters run in the front end file for a split ACCESS
database, and as such are "unique" for that client. So you'll be fine with
what you want to do.
 
Thanks Doug (everything other than the tables is distributed; I understand
from what you wrote that there will be temporary tables created at each
client station and conflits of the nature outlined in my question will be
obviated.)
 
Back
Top