Microsoft.Jet.OLEDB question....

I am having problems with a webpage that connects to an Access97 database using an ADODB connection. I think that I am having compatability problems, I have access97, but am running Windows 2000 professional. When I go to control panel and look at the list of drivers I have, neither Microsofl.Jet.OLEDB.3.51 or 4.0 are listed. I downloaded MDAC 2.6 but all I could find for 4.0 is Jet 4.0 Service Pack. Could someone please tell me what versions I should be using, where to go to download them, and once I download the Jet.OLEDB, how I get that in my list of drivers. Please be pretty specific, because right now I am feeling quite stupid!!!!

Thanks for any help!!!
Cady :confused:

4.0 will work with both Access 97 and 2000 databases.

The 4.0 driver comes automatically with these latter versions of windoze...Perhaps what you mean is, when you are configuring the system dsn? The driver name is Access.

Ok, thanks Radames, maybe you can help me, I apparently don't know how to connect to the database. I have a database call Inventory with a table call Categories with 3 fields called Category, subcategory, and subsubcategory ( I wasn't the one that named this database!!!) and I need to be able to populate 3 drop down boxes with these fields the second and third are populated depending on what the user chooses from the first and second boxes. When I go to the control panel/Data Sources (ODBC)/System DSN, I have Inventory for the Name and Microsoft Access Driver (*.mdb) for the Driver. Could you (or anyone else) help me with the code part to connect and populate the drop down boxes. I have done something like this before but it was a very long time ago and I can't remember how I did it!! Help please!
Cady :)

You don't use ODBC datasources with OLEDB.

You need to connect using the Provider connection string:


cnConn.ConnectionString = "Provider=Microsofl.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("MyDatabase.mdb") & ";"