You can query across databases in Oracle and Sql Server, with a little work. I'm not sure about access. <BR>It really would be easier to just link the tables I would think.

That means they’re faster than Access queries. Transact-SQL (T-SQL) provides procedural extensions to SQL, allowing you to build more sophisticated queries.

i'd like to make a query in access (and eventually SQL 2k) that will combine a table of activities (each row with a unique activityID and activityName) along with a table of activityToUsers (each ...