Microsoft Access - is it possible to create stored procedure in ms access?

Asked By kiruba .e on 12-Jun-12 09:36 AM

Hi,

Is it possible to create stored procedure in ms access 2007 or 2003 like in SQL Server.?

If so, please guide me or helpt to create.

Thanks
kiruba.e

Jitendra Faye replied to kiruba .e on 12-Jun-12 09:51 AM

Refer these links-

http://support.microsoft.com/kb/202116

http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/001d5320-8b2f-4000-a6d6-14af25939266

http://stackoverflow.com/questions/7288074/can-i-create-stored-procedures-in-ms-access-2010

Robbe Morris replied to kiruba .e on 12-Jun-12 11:51 AM

Yes. You do this with DAO. Here's our help sheet to get you started:

http://www.eggheadcafe.com/training-topic/Microsoft-Access-Schema-DAO/95/Access-Schema.aspx

TSN ... replied to kiruba .e on 12-Jun-12 11:59 PM

hi..

you can refer this link

http://support.microsoft.com/?kbid=202116