Create stored procedure in MS Access?

Question

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

Answer 1

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.