Create stored procedure in MS Access?
ms-access, stored-procedures
Solution
I know it is possible to create a `Stored Procedure` directly in access but it isn't pretty to do.
Your best options from here would be to :
- Simulate a `Stored Procedured` using a function. I found a tutorial here. But I haven't tried this approach.
- Another Popular approach seems to be to import an `SQLServer` `Stored Procedure` and Import it in Acess. Try this link if you like this approach.
- If your using MS Access 2010, StoredProcedures will be listed in the tables tab under `Named Macros`.
Hope this helps.
Problem
I would like to know if it's possible to create a `StoredProcedure` to `Insert` data in an Acces database. I've tried a couple of thing but nothing so far seem to do the trick. Thanks