MS Access procedure from VB.net

[Guest]

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

 

[Cor Ligthert[MVP]]

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

 

[Paul Clement]

¤ 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)

 

[Guest]

Hi Cor,

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

Thanks,
M. Wilson

 

[Cor Ligthert[MVP]]

Great link Paul,

Cor