Connecting to Access 2007 database

Question

I'm somewhat new to VB.NET programming but have several years working with the MS Office object models and VBA.  In a VB.NET Windows forms project I'm trying to create a connection to an Access 2007 database to retrieve some user information and then update some records in various tables in that database.  I've tried over and over again to create a data connection in Visual Studio 2008 using the built-in wizard, but always get a message stating there's an error in my connection string.  Does anyone have the experience and time to show a newbie how to achieve this?  Thanks in advance.

Ken