Hi Mark,

The database which you want to connect to, is Access 2007. Your local computer only has the neccessary files to talk to Access versions upto and including 2003. Therefore, in order for your local machine and indeed your code, to communicate with your database, you will need to install or upgrade the office libraries/certain Office files upon your computer.

One way of doing this would be to upgrade your local copy of Office 2002 to an Office 2007 version, another way would be to install Office 2007 onto your computer alongside your existing Office 2002 version and the third and perhaps easiest option would be to install the Office 2007 driver pack which has already been suggested above.

As for your connection string and related to your last question/post there, I would suggest you research what a connection string is to begin with. First off, this is direct from MS:
A connection string is a string version of the initialization properties needed to connect to a data store and enables you to easily store connection information within your application or to pass it between applications. Without a connection string, you would be required to store or pass a complex array of structures to access data.
Basically, to make a connection to a database, several items of information are required to be known. The first is the type of the database, the second is the location of the database, then you may have valid login or authorisation information for this specific database . These are the basic items of information required before VB will make the database connection. A connection string is a ";" delimited string representation of these items of information.

Once you grasp this part, the connectionstrings site, and indeed the individual ; separated parts of the connectionstring examples shown upon that site should fall slowly into place. To further explain your last post, the provider connectionstring specifier details the type of database you are wanting to connect to. Using the following, once you've set your machine up to talk to Office 2007 applications, will allow you to connect specifically to an Office 2007 Access database:
Code:
Provider=Microsoft.ACE.OLEDB.12.0;
Next up, the Data Source specifier details the location of your database, so you need to add this in after your equals sign, like this:
Code:
Data Source=C:\myFolder\myAccess2007file.accdb
It looks as though the connection string in your post 6 may well work if that database location is right and you have your machine setup to communicate with Office 2007 applications properly.