(Thanks to all who responded to my question yesterday regarding making DSN-less SQL connections.)

My data source will consist of 16 SQL Server databases. Each database represents one of our company's divisions, and contains identically named and structured tables. For example, each database contains a table named APVENDOR, each with identical field names, types, & lengths. Is it possible to set up a single view for use in accessing these tables, simply switching the active database and table depending on which company division the user chooses to be working with? I don't really want to set up sixteen potential views for each table or situation that I need to handle.

Using advice received yesterday, I have been working with connections and remote views. Once I have set up a remote view, I don't seem to be able to switch the database. "Hacking" the .dbc file reveals that the database name resides in a memo field, but I don't see a simple way to change that setting.

Thanks in advance for any assistance,
Randy