how to create Stored Procedure

eyes · Jan 19, 2006

I am using vb basic.net 2003 and MS access as database.
I read a few tutorials about creating stored procedures. The instructions were go to server explorer and right-click on database stored procedure to create a new procedure. The problem is, there is no such option when i follow suit.

is this because i am using vb basic standard and not visual studio?
How else can i try to create a stored procedure?
Please help.......

PlausiblyDamp · Jan 19, 2006

If anything it is probably Access itself that doesnt support stored procedures.

Nerseus · Jan 19, 2006

From this old thread I think you can create procs in Access, at least by using Code. I have no idea if theres a way to do it through the Access GUI.

[edit]Heres another link I found by googling for:
"CREATE PROC" Access

http://www.devcity.net/PrintArticle.aspx?ArticleID=18[/edit]

-ner

how to create Stored Procedure

eyes

New member

PlausiblyDamp

Administrator

Nerseus

Danner