can we create stored procedures in MS Access database

[ChennaiBabu]

hi all, greetings.I have a doubt regarding the creation and execution of stored procedures.Can any one tell me how to create a stored procedure in MS Access database and how to execute it? Thanks in advance. Babu

[mysorian]

You need to create an Access Project. You may refer to my article on this at: http://www.angelfire.com/vt2/hodentek/[^] This being said, Access 2003 :cool:does not support Access project with SQL 2005 Server.

[ra ra ra ra]

Simple answer - NO unless as mentioned by someone else you are creating an MS access project to hook up to a sql server, if so its just a SQL server stored proc But if its a normal access database you should be able to write your own scalar functions (single return value), but you can not write functions that will return a recordset. unless the consumer of the recordset is another vba function... hope that makes sense, I've not had my coffee yet! Mr ra ra