Create Connection To Database

[Totally Confused]

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

'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'

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

[Totally Confused]

hehe....Sorted.

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