Last post Sep 22, 2013 04:56 PM by Mikesdotnetting
Sep 22, 2013 10:39 AM|ehsansh|LINK
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
Sep 22, 2013 12:13 PM|shabirhakim1|LINK
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.
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.