My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to ...

When the application was originally written, SQL Server 2000 was the database and functionally partitions were pretty much this (multiple tables with views UNION-ing them).