How to make a real-world application in VBA+Access '03: what is the best way to connect to a DB?

First of all this is a question: "what is the best way to connect to a DB? " so don't delete it. thanks

I'm now facing a real problem at code organization when I connect to a DB with Access, when building forms. I'm coming from a MVC background and I don't see any simple way to do this. The DB connecting proc开发者_开发知识库ess is quite overkill for what I'm know right now and that's why I ask you guys if you know what are the best practices, or design patterns, for building real-world MS Access Forms that connects to a DB. (and of course reuse code, be DRY) Are there any great frameworks to help my "difficult" life?

If the data resides outside Microsoft Access (e.g. in another database platform), you could use linked tables. This would separate the interface of the Microsoft Forms from the actual data.

http://office.microsoft.com/en-us/access-help/link-tables-in-an-access-project-by-using-the-link-table-wizard-adp-HP003089371.aspx