Cannot Get VB.Net Standard to connect to a MSAccess Database.

[Mark]

Hi,

I am trying to create an ASP page in MS Visual Basic .NET Standard 2003.

But every time I put an OleDbDataAdapter on a Component1 and go through the
Data Adapter Configuration Wizard I receive the following error when I
enter the SQL to select some records.

The connection could not be opened because of the following error:

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

I have since installed MDAC 2.7 but still get this error message.

Can any one help

 

[Gerry O'Brien [MVP]]

Certainly.

In your application, go into the references section. You will likely find
that 2.5 is still being referenced. Remove that reference and add a
reference for 2.6 instead.

 

[Mohamoss]

Hi Mark
You need to update the reference in your visual studio to reference the
new version of the MDAC dll , this is not done by default when you install
a new version as you might have applications that are dependant on the
older version. Hope this explains it.

Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

 

[Mark]

In VB 6 I would go to Tools>References

How do I do this in .NET?

Thanks
Mark.

 

[Gerry O'Brien [MVP]]

In solution explorer on the right, you will see a References section.
Expand it to see current reference and select the old version and delete it.
Then right click and choose Add Reference.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)