Im wondering if someone can give me some explanation regarding these layers of communication. If find them quite confusing. In particular, the hype regarding how great Access ADP files are because of their native connectivity with SQL Server. In my limited experience with them, I have found them to be rather cumbersome and limiting. I appreciate the speed advantages they have over linking SQL tables to an MDB file, but theres some downsides as well. Not being able to use local tables is definitely one of them. If you have full access to SQL server, then you can create your views, sp's, triggers, tables etc, then using ADO you can open or call any of these objects directly from an MDB file. At the same time you can link to other data sources using ODBC. Is using ADO to call an sp or open a recordset from MS SQL the same as connecting with an ADP file and binding views to your forms.
Sorry if this question is kind of all over the place but Id like to get these things straight, to help me make decisions in designing future apps.