Consuming a .NET 3.5 Assembly in MS Access 2003

[Ben]

Hi all!

I am confronted with this question if MS Access 2003 can consume a .NET 3.5
assembly or not. Is this possible?



Thanks,

Ben

 

[Albert D. Kallal]

Hi all!

I am confronted with this question if MS Access 2003 can consume a .NET
3.5 assembly or not. Is this possible?

It should be possible, since you can do this for vb6, and ms-access can use
"com" objects the same like vb6 can.

Here is an article describing the process of consuming .net from vb6.

http://support.microsoft.com/default.aspx?scid=kb;en-us;817248

and this should help too

http://msdn.microsoft.com/en-us/library/tzat5yw6.aspx

I not done the above, but it does hint that the .net app has to be correclty
compiled with options to expose the code as a windows "com" object. Once it
is a com ojbect, then word, excel, vb6, access etc. should be able to
consume the .net object.