We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
Possible to create stored procedures in Access by code?[Answered]
2 replies
Last post Sep 22, 2013 04:56 PM by Mikesdotnetting
Last post Sep 22, 2013 04:56 PM by Mikesdotnetting
Member
87 Points
296 Posts
Possible to create stored procedures in Access by code?
Sep 22, 2013 10:39 AM|ehsansh|LINK
Hi there.
I know in Access 2010 we can have named macros.
I want to know if it's possoble to create them with a code like this:
CREATE PROC Test
@ID int
AS
...
Star
10830 Points
2409 Posts
Re: Possible to create stored procedures in Access by code?
Sep 22, 2013 12:13 PM|shabirhakim1|LINK
Hi
Access 2010 has both stored procedures, and also has table triggers. And, both features are available even when you not using a server (so, in 100% file based mode).
If you using SQL server with access, then of course the stored produces are built using SQL server and not access.
For access 2010, you open up the table (non design view), and then choose the table tab. You see options there to create store procedures and table triggers.
http://stackoverflow.com/questions/3287545/how-do-i-make-a-stored-procedure-in-ms-access
All-Star
194886 Points
28106 Posts
Moderator
Re: Possible to create stored procedures in Access by code?
Sep 22, 2013 04:56 PM|Mikesdotnetting|LINK
Yes, you can use DDL to create saved queries (which is what stored procedures are called in Access). You can pass this DDL to the CommandText property of an OleDbCommand and execute it against the database.