I have worked with Access 97 and 2000 over the last few years and found that Access Linked table to SQL is fast approach to solving business needs especially when Scope is not well defined.  The Linking table approach is the basic method but will bite you if your SQL table structure changes or your office version upgrades. Deployment and modifications are tricky to manage.  You can reference SQL stored proc in Pass-Through queries and really have a robust method of accessing data to your Access front-end without compromising resources on your SQL Server.  I also recommend a well defined connection string to SQL so you can trace calls from the Access front-end.

In a nut shell I would use linked table in Develpment only to get forms running and convert to Stored Procs for production.  The development cycle is short for Access compared to .net and c# interfaces.  But Access is a memory hog on your client so be careful with long term planning.

I'm looking forward to article 3 with access project.  I have not had time to explore this method and from what I have read seems to be the answer.