Utilize .NET Class from Microsoft Access

[Rob Hill]

I am using Microsoft Access as a prototype for a database application that
will eventually be rewritten in VB.NET. I would like to use Access for
prototyping future versions of the application.

In .NET, we are wrapping the database tables into classes and I want to use
them from Microsoft Access.

Is this possible?

Thanks,

Rob Hill
(e-mail address removed)

 

[Herfried K. Wagner [MVP]]

I am using Microsoft Access as a prototype for a database application that
will eventually be rewritten in VB.NET. I would like to use Access for
prototyping future versions of the application.

In .NET, we are wrapping the database tables into classes and I want to
use
them from Microsoft Access.

You can implement the functionality in a .NET class library and expose the
functionality for COM interop:

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

 

[Brendan Reynolds]

You can't reference a .NET assembly from Access, or from any other VBA host,
because VBA doesn't use the CTS. You can call a .NET Web Service from Access
2002 or 2003 using the Office Web Services Toolkit which can be downloaded
from Microsoft's web site.

What would you do with your classes in Access anyway?

People use the word 'prototype' in two different ways. It can mean
'something that I show you, then throw away', or it can mean 'something that
I build on as the foundation of the finished project'. Access and .NET are
sufficiently different that an Access prototype of a .NET app will fall very
much into the first category. If you had the second meaning in mind, I don't
think that will work out very well.

 

[Steve Long]

Great idea Herfried. I actually have to do that in another environment.
Don't like it but it work and you can even debug so what the hey.

Steve