odbc and access driver

[J.X.]

my ODBC won't recognize access2000. so I get Jet version 4.0 service pack 3 and download it. I also put the file dao360.dll under DAO like what it says. but my access drive in the ODBC is still 3.51 instead of 4.0 and I think that is probably why it still couldn't recognize the access2000.
can anybody tell me what else I should do to make this work?
thank you very much.

[Clunietp]

Hi JX

I tried to create a DSN for Access 2000 and open it with DAO 3.6 and ADO with the Jet 4.0 provider, but it appears as if you cannot use a DSN with an Access 2000 database, you'll need to use DAO 3.6 or ADO directly....

[Tonatiuh]

Could you put the line code you're using to open the DB?

[J.X.]

I don't have the code for connection. I only choose the connection string in the property window and created a dsn for the access driver.
maybe I need to write code instead. what should I put down for the code?
thanks for advance

[Tonatiuh]

Well, you must can do it by the properties window but, I prefer to use code to do it and use ADO instead DAO.

A sample code to open the DSN database is:

DIM Cn as ADODB.Recordset
strConnect = "DSN=" & CapContDSN & ";UID=;PWD=;OLE DB Services=-1;"
Cn.ConnectionString = strConnect
Cn.Open
Cn.CursorLocation = adUseServer


I hope this point you in a better way.

Good Look!