By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,947 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,947 IT Pros & Developers. It's quick & easy.

MS Access procedure from VB.net

P: n/a
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

Oct 19 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Oct 19 '07 #2

P: n/a
On Thu, 18 Oct 2007 19:57:00 -0700, M. Wilson <MW*****@discussions.microsoft.comwrote:

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)
Oct 19 '07 #3

P: n/a
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]" wrote:
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

Oct 19 '07 #4

P: n/a
Great link Paul,

Cor
Oct 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.