Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Closed Thread
 
Thread Tools Rate Thread Display Modes
Old 08-15-2008, 12:50 PM   #1
Banana
split with a cherry atop.
 
Join Date: Sep 2005
Posts: 6,315
Thanks: 0
Thanked 89 Times in 72 Posts
Banana is a glorious beacon of light Banana is a glorious beacon of light Banana is a glorious beacon of light Banana is a glorious beacon of light Banana is a glorious beacon of light Banana is a glorious beacon of light
Consuming .NET components within Access/VBA

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
Attached Files
File Type: zip NET2Access Demo.zip (180.4 KB, 1773 views)
File Type: txt READ ME.txt (6.1 KB, 1259 views)

__________________
If relation-valued attributes and arbitrarily complex types are wrong, then I don't wanna to be right!
Founder of 'Blame the Developers First' crowd.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by Banana; 08-17-2008 at 05:43 PM. Reason: Thanks, Pleasure!
Banana is offline  
The Following 3 Users Say Thank You to Banana For This Useful Post:
hassanogaibi (06-28-2016), sigma788 (02-18-2013), winshent (06-09-2011)
Old 08-17-2008, 05:30 PM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,123
Thanks: 13
Thanked 1,350 Times in 1,286 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Thread is now open for maintenance.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline  
The Following User Says Thank You to Pat Hartman For This Useful Post:
hassanogaibi (06-28-2016)
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relating Assembled Part Numbers to their components dbadminnewbie General 1 02-11-2008 01:41 AM
Access to .Net Summerwind Modules & VBA 3 01-26-2007 06:57 PM
New Page Issue in Crystal .Net TJBernard Crystal Reports 1 06-06-2006 01:22 PM




All times are GMT -8. The time now is 08:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World