Installing DLL

[Martin]

Hi, I need to get some help on the following issue:
Is it possible to install any DLL on my pc and then make reference to it in
order to call its functions from my access code?
If so, how should I do it?
Thanks in advance.

 

[Tom van Stiphout]

On Tue, 10 Nov 2009 19:23:39 -0800, Martin <[email protected]>
wrote:

Yes, but it is more complex than you would think. There are three
types of DLLs:
1: classic DLLs. Put them in the Path and write a Declare statement
for its API, and call them. Example: any function in the Windows API.
2: ActiveX DLLs. Put them anywhere and register them with
regsvr32.exe <full_path_to_dll>
Then use Tools>References and set a reference to it. Then use its
classes, methods, events, and properties. Example: ADODB.
3: .NET DLLs. Can only use if they have a COM wrapper (ask any .NET
developer). Use regasm.exe to register them. Then proceed like #2.

Happy programming,

-Tom.
Microsoft Access MVP