Fantastic article, Andy! I guess you would not recommend to have a lot of links like this concurrently across the network. I am currently working the other way, transforming an Access 2K app with 170 tables linked to a Server- based .MDB file, and concurrently running on 12 workstations. The network goes like cold molasses!
My goal is to convert to an Access front-end, linked only to a "local" MDB file and for the rest, to use pass-thru queries and ADO Commands to get access to the same data in an SQL Server database. Going well so far, but a lot of conversion work.
I particularly like your article, as I have just about lived 24/7 with Access and VBA coding for the past 6 years. and what you describe is very familiar ground.
(very much a beginner in SQL coding. Still trying to fully utilise Query Analyser features)