Reference .NET assembly in Access?

[Mike]

Hi. I've built a .NET assembly (3.5) and when I attempt to reference it
within an Access 2007 app I get the error "can't add reference to the file".
I've set the .NET assembly to be visible to COM interop, but still I cannot
access it from Access.

How do I reference a .NET assembly from Access?

Thanks!

 

[Albert D. Kallal]

Hi. I've built a .NET assembly (3.5) and when I attempt to reference it
within an Access 2007 app I get the error "can't add reference to the
file".
I've set the .NET assembly to be visible to COM interop, but still I
cannot
access it from Access.

How do I reference a .NET assembly from Access?

Thanks!

You have to ensure that you setup the .net class to have some type of public
interface exposed.

I am not a .net guy, but a normal assembly in .net is not a com object that
can be consumed by windows applications as an com object.

You have to setup the.net app to expose itself as such, and then register it
correctly.

Here is some more info that should get you going:

http://support.microsoft.com/?kbid=813809

 

[Banana]

Albert is correct. It's not enough to check the COM box in VS.

I wrote a sample database demonstrating how to consume .NET component
from Access/VBA at:

http://access-programmers.co.uk/forums/showthread.php?t=155129

HTH.

Banana

 

[Mike]

Thank you - I will be checking this out!

Albert is correct. It's not enough to check the COM box in VS.

I wrote a sample database demonstrating how to consume .NET component
from Access/VBA at:

http://access-programmers.co.uk/forums/showthread.php?t=155129

HTH.

Banana