I tried to develop a corporate web site having several Access database 
located in different folders under the virtual root. Each of these 
folders are for different departments of the organization.

The central page requires gathering and displaying the information 
contained in these distributed databases; I was tempted to link the 
tables from thses distributed database into the centrally located 
database. I used UNION queries, and it worked fine in my development 
environment (WinXP IIS 5.0, server & client same PC using 
http://locahost/). But when I hosted the site in a remote test server, 
the linking failed, because it was missing the local paths of the linked 
tables.

What could be an alternate solution to implement this distributed 
database and tables while still using MS Access database. Please someone, 
help me.

Thanks in anticipation.