Dynamic Connection to SQL Server DB from Access

[dfrazell]

We have a backend SQL Server that has 6 identical database schemas one
for each region (soon to be 8). I need to create a frontend reporting
system that will dynamically switch to the regions database when
selected. Currently our Access database has a link to each table
(100's of tables) in each regions database and each report is
duplicated in each region.

How can I create a single report that will dynamically switch table
connections based on the region selected? We are using Access 2002 for
our reports.

Thanks,
DFrazell