How to write Storedprocedures in Ms-Access

Posted by Rrana under VB.NET on 7/20/2012 | Points: 10 | Views : 4321 | Status : [Member] | Replies : 6
Hi,

How to write Storedprocedures in Ms-Access and how to call them into windows vb.net application


Thanks in Advance

Sucharitha Goud
Bank Of America..



Responses

Posted by: Ranjeet_8 on: 7/20/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
look at this link
it will help u to create sp in MS access
http://support.microsoft.com/?kbid=202116

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: GSM_GSV on: 7/20/2012 [Member] Starter | Points: 25

Up
0
Down
please refer the below link.
Also, you can download the source code.

http://devcity.net/Articles/18/msaccess_sp.aspx

---------------------------------------
Live the life you've dreamed

Regards
MADHU

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/20/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Use MS Access 2010,
You see options there to create store procedures and table triggers.

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
Please refer this http://stackoverflow.com/questions/8779586/how-to-create-and-use-stored-procedure-on-ms-access-mdb-file-with-vb-net-wind

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
http://www.dotnetspider.com/forum/313496-How-write-Storedprocedures-Ms-Access.aspx

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as answer if it helps...,That motivates...!!!

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response