Using .NET DLL's in MS Access 2003 (Part Of MS Office)

[young_virus]

I have a problem loading a DLL file to Access. The DLL is in .NET format.

Do you have any idea if it is possible and how to create the DLL in .NET in
that way, that Access will be able to use it? Or maybe .NET DLL's shoud be
registered In Access in special way?

 

[Brendan Reynolds]

You can't call a .NET DLL directly from VBA. You can call web services from
VBA in Office XP or Office 2003 if you install the Office Web Services
Toolkit, so a possible workaround would be to develop a web service that
wraps your DLL and call the web service from your VBA code.

You can download the Office XP Web Services Toolkit at ...
http://msdn.microsoft.com/library/d.../en-us/dnxpwst/html/odc_wstoolkitoverview.asp

.... or the Office 2003 Web Services Toolkit at ...
http://www.microsoft.com/downloads/...8a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en

 

[young_virus]

How can I develop a web service that wraps my DLL and call the web service
from my VBA code?

 

[Brendan Reynolds]

For how to call the web service from your VBA code, see the links I posted.
There's documentation there explaining how to use the Web Services Toolkit
to call the web service. Developing the web service itself is, I'm afraid, a
subject that is beyond the scope of a newsgroup post, as well as being
off-topic in this newsgroup. If you have specific questions about developing
web services though, there's a web services newsgroup at ...

http://support.microsoft.com/newsgr...otnet.framework.aspnet.webservices&sloc=en-us

For background information and learning resources see ...

http://msdn.microsoft.com/webservices/

There's also ...

http://www.asp.net/QuickStart/webservices/

.... but that site focuses heavily on ASP.NET 2.0.

 

[Danny J. Lesandrini]

I wrote an article at Database Journal on the subject of hitting a web service
from MS Access.

http://www.databasejournal.com/features/msaccess/article.php/3567511