Multiple Users working same Table

[Michael Carakatsane]

I have a form that contains a subform. The query for
subform is a list of selected records from a master table.
To select records, a user Inserts records into a table
called ?Summary? that contains record numbers of the
selected records. When I want to work with the selected
records, I do a join of ?Summary? and the Master Table and
get just the records that the user has chosen.

When I move to a multi-user environment, if people are
working at the same time, they all are adding records to
the same ?Summary? table. Not what I need. I need their
work to stay separate.

I have learned how to give each a different ?Summary? table
called ?Summary201,Summary202,...? The problem is that
subform that displays these records must ask for Summary201
or Summary 202 or... How do I get this Join to work with
these numbered tables? I can not write separate subform
statements for each user and the Query does not seem to
have a way to take numbered tables in some VBA coding?

Alternately, maybe there is a way to keep ?Summary? local
to the users and have the main body of tables on the
server. In this way, each person works with their own
?Summary? table. If it is possible, I do not know how to
do it.

Thanks for any help that can be given.

Michael

 

[Steve Schapel]

Michael,

Basically you need to have your database set up such that the
permanent data tables are in one one .mdb file, called the backend,
and each user links to this from their own copy of the frontend, which
contains the forms, reports, queries, etc, and also the Summary table.

By the way, do you really have the table named ?Summary? with the ?s
in it? If so... not a good idea!

- Steve Schapel, Microsoft Access MVP