creating Stored Procedure in Access 2007

[shraddha]

In Microsoft Office Access 2007, why i cannot see Stored Procedure icon?


please someone help me out
i want to create Stored procedure in MS access 2007

[NTC]

in Access stored procedures are Modules. you will find them in the list of objects.

[NoellaG]

Hi,

do you mean you want to create a stored procedure on a back-end SQL-server? In this case you have to start an .adp project which is only possible in Access 2000 or 2003.

kind regards
Noëlla

[dch3]

In Microsoft Office Access 2007, why i cannot see Stored Procedure icon?
please someone help me out
i want to create Stored procedure in MS access 2007

Access does NOT support Stored Procedures. Hence, there is no stored procedure icon.

Stored Procedures are modules that reside within a SQL Server database that provide data manipulation written in T-SQL and that can be called directly or via a trigger on a SQL Server table.

Access has Modules which are collections of procedures and functions that perform a function written in VBA, which, if needed, can manipulate data. The individual procedures are called on demand as the result of an event that occurs in the GUI and not when data is added to a table (Access 2010 excluded).

There is a distinct difference.

That being said, what are you trying to accomplish?

Also, this forum is probably you're best support for Access support.

http://social.msdn.microsoft.com/For...essdev/threads

[DistillingAccess]

Access does NOT support Stored Procedures. Hence, there is no stored procedure icon.

I guess you are saying something very wrong and I am also looking for the same answer:
http://www.aspfree.com/c/a/Microsoft...Access-2007/2/

I am trying to call a store procedure but my MS Access 2007 doesn't show the option in the Create Tab/ Other.

I went to Access Options/ Customize/ Store Procedure Tools | Design Tab (that is in the scroll bar Choose commands from) but didn't find the place where to include this option. Any clue?

[pbaldy]

I suspect you will only see those options if you have opened an ADP, not if you've opened an MDB/ACCDB.