designing with tables in a multi-user environment

[livia]

Hy,
A problem from a non-experimented programmer in a multi
user environment:
I have a database MasterAchat which contains a linked
table tblPlanAchat to several databases
Achat031, Achat032...) depending on users choice (one
at a time, of course). The table is used as record source
for a report. Question: can I use this report in a multi-
user environment?
Example:
One user wants to open the report so that the
table tblPlanAchat attaches to the database Achat031
and another user wants to use the table so
that tblPlanAchat attaches to the database Achat032.
Is it possible to do this with Access?
Regards

 

[Duane Hookom]

This will work if everyone uses their own copy of MasterAchat.