How to create a .NET library to be used by MS Access 2007's VBA?

Question

I have used .NET 3.5 with C# to create functions to gather data from a product's web service. Now we have a need to be able to get at that data in a Microsoft Access 2007 application.

I am not particularly familiar with VSTO et al, and I don't want to have to fuss with anything on the MS Access side--I'll leave that to our VBA expert. But I would like to make a library that our Access developer could easily use from his VBA code.

Can you point me in the right direction?

You do realize Access can consume a web service directly, right? — David-W-Fenton
– David-W-Fenton, Commented Sep 30, 2010 at 2:36
@David-W-Fenton Nope, didn't realize that... I don't do more than troubleshoot MS Access. But I'll look into it--thanks! — ewall
– ewall, Commented Sep 30, 2010 at 3:21

Dirk Brockhaus · Accepted Answer · 2010-09-29 14:54:52Z

1

Make your C# library ComVisible and you can access it via ActiveX. But be aware of the fun part: You have to register it on all machines you want to use this!

answered Sep 29, 2010 at 14:54

Dirk Brockhaus

5,0923 gold badges40 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CodingGorilla · Accepted Answer · 2010-09-29 14:55:37Z

0

I believe the simplest way of accomplishing this is to make your assembly and classes available via COM. This might be a good starting point for you: http://msdn.microsoft.com/en-us/library/zsfww439%28v=VS.90%29.aspx

answered Sep 29, 2010 at 14:55

CodingGorilla

19.9k4 gold badges48 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to create a .NET library to be used by MS Access 2007's VBA?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related