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'

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