MDAC 2.5-2.6

[JaneB19]

Hi,

I'm hoping that somebody that's had this problem and solved it before can help me out? PLEASE!!!

At the beginning of last week everything seemed to be working fine but by the end of the week...!

When trying to open the connection to my Access database I get the following message:

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 2.53.6200.0 was found currently installed.


It also highlights dbconn.Open() as the problem!

I've downloaded version 2.6 from the Microsoft website and installed it but for some reason it can only find version 2.5 still.

Maybe I'm being silly, but is it meant to be in a particular folder? I've put version 2.6 in the Web Matrix folder in the 'Program Files'.

Thanks for any advise or help that can be supplied!

Jane

 

[jzelhart]

Did you restart your computer? MDAC sometimes requires this but doesn't tell you to do it.

Also, did you run the MDAC installation? Just downloading it and putting it somewhere won't work, it installs stuff to the Windows System directory.

You may also try installing the latest Jet Updates as well.

Hope everyone is having a great day!

Thanks - Jennifer

 

[JaneB19]

Yeah, I've restarted my computer several times, just incase! I also ran the Installation but I still get the error message saying that version 2.5 is installed.

I take it I can get the Jet updates off the Microsoft site?!

Thanks

:0)

 

[jzelhart]

Yes go to the downloads - Select Jet Database Engine as the Product. It will be one of the first ones. Also you might try MDAC 2.8 instead. That is the one that I am running with no problems.

Hope everyone is having a great day!

Thanks - Jennifer