Consuming .NET components within Access/VBA (1 Viewer)

Status
Not open for further replies.

Banana

split with a cherry atop.
Local time
Today, 15:46
Joined
Sep 1, 2005
Messages
6,318
This is an demo showing how to use .NET libraries to extend Access's functionality.

This was written with Access 2003, Visual Basic Express Studio 2005 (free) using Microsoft .NET framework 2.0.

The demo references a C# library IntX, which is an arbitrary precision library enabling operations on large numbers without limitations imposed by Long Integer or even 64-bit BIGINT (the only limitation is availability of computer's resource), and how it can be implemented within Access to enable saving and managing large numbers.

I've also included a .PPT which was used to showcase the demo as well as README to help people get a hang of it.

This is not the only way to do it, but hopefully the most simple way to implement such functionality.

NOTE:

To get the sample working, you need to put it to C:\ directory as the library's path is hardwired.

Also, you need to have 2.0 framework installed and register the library. To register, use the Command Prompt:

Code:
cd C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
regasm "C:\NET2Access Demo\IntX VB\BigIntX.dll" /tlb: "C:\NET2Access Demo\IntX VB\BigIntX.tlb" /codebase

You can download framework 2.0 from MSDN for free as well.

NOTE:

If you are having problem with long names, verify that you are using cmd.exe, not COMMAND.COM (which is just present in Windows XP for backward compatibility). Alternatively, use this instead:
Code:
cd C:\WINDOWS\MICROS~1.NET\FRAMEW~1\V20~1.507
regasm C:\NET2Ac~1\IntXVB~1\BigIntX.dll /tlb: C:\NET2Ac~1\IntXVB~1\BigIntX.tlb /codebase
 

Attachments

  • NET2Access Demo.zip
    180.4 KB · Views: 2,266
  • READ ME.txt
    6.1 KB · Views: 1,518
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom