Error Adding MS Access Reference to VB.Net Project

[Mark]

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\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"
key being added:
"c:\windows\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"

I'm running Visual Studio .Net 2002.

Thanks for you ideas comments.
Mark

[Ken Tucker [MVP]]

Re: Error Adding MS Access Reference to VB.Net Project

Hi,

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

http://msdn.microsoft.com/library/de...dc_oxppias.asp

Ken
------------------
"Mark" <Mark@discussio ns.microsoft.co m> wrote in message
news:E6D01E83-9257-44C8-A08B-C1CAFF823C2A@mi crosoft.com...
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\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"
key being added:
"c:\windows\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"

I'm running Visual Studio .Net 2002.

Thanks for you ideas comments.
Mark

[Mark]

Re: Error Adding MS Access Reference to VB.Net Project

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".

[Mark]

Re: Error Adding MS Access Reference to VB.Net Project

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.Offic e.Interop.Acces s.Application

Thanks for your suggestion.

Mark


"Ken Tucker [MVP]" wrote:
[color=blue]
> Hi,
>
> Try using the office primary interop assemblies instead of add a
> reference to the program
>
> http://msdn.microsoft.com/library/de...dc_oxppias.asp
>
> Ken
> ------------------
> "Mark" <Mark@discussio ns.microsoft.co m> wrote in message
> news:E6D01E83-9257-44C8-A08B-C1CAFF823C2A@mi crosoft.com...
> 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\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"
> key being added:
> "c:\windows\ass embly\gac\adodb \7.0.3300.0_b03 f5f7f11d50a3a\a dodb.dll"
>
> I'm running Visual Studio .Net 2002.
>
> Thanks for you ideas comments.
> Mark
>
>
>
>[/color]