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.

As a result, you can now create a PROC SQL view, DATA step view, or SAS/ACCESS view with DBMS data. For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL ...

The EXECUTE statement cannot be stored as part of an SQL Procedure Pass-Through Facility query in a PROC SQL view.

While I have never used SQL Server Reporting Services, it seems to have a lot of advantages over an Access-based reporting tool.

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work ...