Create Connection To Database

Hi,
I am trying to set up a DSN-Less connection to an Access 2000 database but am struggling a little bit.

I am using

Code:

---

'Straight out of a book
CN.ConnectionString= "Provider=Microsoft.Jet.OLEDB.3.51;_
  Data Source=E:\Football Database\Football.mdb"
CN.Open

---

but all I keep getting is an error saying 'Unrecognised Database format' :confused:

I have set up a reference to Microsoft ActiveX Data Objects 2.5 Library.

What am I doing wrong?

How can I connect to this database

Thanks

Totally :confused:

hehe....Sorted.

Should have read the other posts first. This was answered a few questions down.