Error Adding MS Access Reference to VB.Net Project

[Guest]

I'm getting the following error when I add Access as a reference to my project:

A reference to 'Microsoft Access 10.0 Object Library' could not be added.
Converting the type library to a .NET assembly failed.
A dependent type library 'OWC10' could not be converted to a .NET assembly.
A depedent type library 'ADODB' could not be converted
to a .NET assembly. Item has already been added.
Key in dictionary:
"c:\windows\assembly\gac\adodb\7.0.3300.0_b03f5f7f11d50a3a\adodb.dll"
key being added:
"c:\windows\assembly\gac\adodb\7.0.3300.0_b03f5f7f11d50a3a\adodb.dll"

I'm running Visual Studio .Net 2002.

Thanks for you ideas comments.
Mark

 

[Ken Tucker [MVP]]

Hi,

Try using the office primary interop assemblies instead of add a
reference to the program

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp

Ken
------------------
I'm getting the following error when I add Access as a reference to my
project:

A reference to 'Microsoft Access 10.0 Object Library' could not be added.
Converting the type library to a .NET assembly failed.
A dependent type library 'OWC10' could not be converted to a .NET assembly.
A depedent type library 'ADODB' could not be converted
to a .NET assembly. Item has already been added.
Key in dictionary:
"c:\windows\assembly\gac\adodb\7.0.3300.0_b03f5f7f11d50a3a\adodb.dll"
key being added:
"c:\windows\assembly\gac\adodb\7.0.3300.0_b03f5f7f11d50a3a\adodb.dll"

I'm running Visual Studio .Net 2002.

Thanks for you ideas comments.
Mark

 

[Guest]

Ken -

I'll try it.

Just curious, is using PIA for Access common in the VB.Net world? Is the
error I explained in my original post common?

I've always used references which has served me well, but granted I'm not a
heavy programmer. So using something "new" always gives me thoughts of
"what am I getting myself into".

 

[Guest]

Just wanted to let you know that PIA worked.

I downloaded the PIA and followed the directions to register the files. I
registered all of the Office PIA, not just the ones associated with Access (i
hope this was not a mistake).

In VB.Net I had to use the following declare statement:

Dim acApp As Microsoft.Office.Interop.Access.Application

Thanks for your suggestion.

Mark