I'll have to do some R&D on the ODBC, Link. Being newer to it, it could be a bit slower going. Queries make sense esp. from a design. I'm hoping I can still use the File Import feature for Access as we'll be getting ina monthly update.
As far as CR not being kind with it's Join's across the multiple db's, I think most of the reporting will be more in the line of summary information from multiple sources. If I turn out really lucky, I be able to keep the in separate subreports, but I'll find out more on the report requests soon.
Thanks again