MS Access procedure from VB.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
¤ 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)
 
Hi Cor,

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

Thanks,
M. Wilson
 
Back
Top