Two DB's One Table

[Icehousman2]

I have a real problem here. I am creating an order tracking program for our customer service department. (Note - I am not an expert with access, but am the best we have) However, we have customer service people located in four different cities, all relatively close. They need to share the same information, and have exactly the same DB's structurally. Linking them all to one table will not work because it takes too long for the Remote Db's to access the information and speed is critical. I was thinking of setting up some type of automated merge with all four tables, but am not sure how to go about this. Any good ideas out there? I'm really stuck. Thanks.

 

[Icehousman2]

Ok, I didn't get any reponses, but I'm going to try again. I know someone out there knows how to do this type of thing. Maybe if I make my question clearer.

I've been working on the problem I stated in the first post. And what I have now is four DB's on servers located in four cities. All include a table with the exact same structure but different names. (I can change the structure) They are called tblOrderCityName. And each db is linked to the other three tables. I was hoping to use a union query to join all four tables and then replace the existing local table, by using a make-table query. But access won't let me do this because the existing table is a source of the make-table query. So I am stuck again. Hope someone can shine some light on this for me. And If I still need to make this clearer let me know.

Thanks