MS Access procedure from VB.net

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M. Wilson - 19 Oct 2007 03:57 GMT

Hello,

Can I run a procedure that resides in an Access database in VB.net? If yes,
I would be ever so greatful if code was provided.

Thanks,
M. Wilson

Reply to this Message

Cor Ligthert[MVP] - 19 Oct 2007 04:47 GMT

M. Wilson,

It depends about what you are talking. MS Access has been a seperated
solution and is now a part of Office which is using databases. (Jet and SQL
server). The Stored procedures in those databases you can easily access
using the command.Executenonquery, the datareader or the executescalar.

You can create iterop to the office application and do then in fact
everything. Beside that you can start access with application.run including
the needed parameters.

Cor

Reply to this Message

M. Wilson - 19 Oct 2007 21:21 GMT

Hi Cor,

I am referring to procedures in modules that I created. Can I call one from
Vb.net?

Thanks,
M. Wilson

> M. Wilson,
>
[quoted text clipped - 8 lines]
>
> Cor

Reply to this Message

Paul Clement - 19 Oct 2007 16:58 GMT

¤ Hello,
¤
¤ Can I run a procedure that resides in an Access database in VB.net? If yes,
¤ I would be ever so greatful if code was provided.

How to run Office macros by using Automation from Visual Basic .NET
http://support.microsoft.com/kb/306682

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Cor Ligthert[MVP] - 20 Oct 2007 06:43 GMT

Great link Paul,

Cor

Reply to this Message

MS Access procedure from VB.net

Free Magazines