.NET component in MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elizabeta - 11 Aug 2004 01:01 GMT

Hi,

(bare in mind I am a novice to VS .NET)

can I create control in VS .NET and incorporate it in my BIG MS Access
application as a activeX component or dll? Is it possible.

And can this component be a form, with UI for creating a new order for
example?

TIA

Reply to this Message

M.L. Sco Scofield - 11 Aug 2004 04:52 GMT

Short answer - No.

Long answer, if you put a COM wrapper around a .NET component, you might be
able to use it as a code resource.

Access has limited ability to use VB 6.0 ActiveX controls. If you are
compelled to write useful ActiveX controls for Access, you'll have to use
VC++.

So the $64,000 question. Why? From a data centric point of view, Access has
better forms that VB ever dreamed of having.

Now, if your question was really; "Can I write a .NET app, VB or C# and
connect to a Jet database?" The answer is a resounding YES!

For that, you need to ask your questions in:
microsoft.public.dotnet.datatools
microsoft.public.dotnet.languages.vb.data
microsoft.public.dotnet.languages.vb.data
microsoft.public.dotnet.languages.csharp

As you mention you are a "novice to VS .NET," you might try using the .NET
groups instead of an Office group.

There are 12 Visual Studio .NET groups at all start with
microsoft.public.vsnet.

There are 49 .NET groups all start with microsoft.public.dotnet.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

> Hi,
>
[quoted text clipped - 7 lines]
>
> TIA

Reply to this Message

Elizabeta - 11 Aug 2004 23:35 GMT

Sco,

Thanks a lot. $64 000 answer: I want to create reusable component, to use
currently in my distribute access application (with other forms, ...) and be
able to use it laater when we migrate to web application. It will be some
activeX component. So, you think I develop it in VC++?

(Regarding the accessing jet database, I have comercial experience, so that
wasn't my question.)

Thank you for your time.

Regards,
Elizabeta

> Short answer - No.
>
[quoted text clipped - 44 lines]
> >
> > TIA

Reply to this Message

M.L. Sco Scofield - 12 Aug 2004 06:05 GMT

Inline...

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

> Sco,
>
> Thanks a lot. $64 000 answer: I want to create reusable component, to use
> currently in my distribute access application (with other forms, ...) and be
> able to use it laater when we migrate to web application.

Interesting.

> It will be some
> activeX component. So, you think I develop it in VC++?

VC++ is going to be you're only hope.

ActiveX controls behave much better in IE than they do in Access.

To be honest, writing an ActiveX control that will work in Access has
brought many an experienced VC++ ActiveX control programmer to their knees.

Access's control container is weak at best. For some insight, take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;202104.

Also, take a look at http://www.microsoft.com/com/tech/activex.asp. It has
lots of links you can follow.

You're best bet for asking questions will be one of the microsoft.public.vc
groups.

> (Regarding the accessing jet database, I have comercial experience, so that
> wasn't my question.)

I wasn't sure. We get a lot of those questions in this group.

> Thank you for your time.

You're most welcome.

I truly wish you luck. You're going to need a bunch.

Sco

> Regards,
> Elizabeta
[quoted text clipped - 47 lines]
> > >
> > > TIA

Reply to this Message

zfz5413 - 20 Aug 2004 16:52 GMT

"Elizabeta" <Elizabeta@discussions.microsoft.com> ????????????

:7DF4C27B-99DD-492B-B0F5-DFE56F007A2A@microsoft.com...
> Hi,
[quoted text clipped - 8 lines]
>
> TIA

Reply to this Message