Stored Procedures

[aaa]

I am reading this article on the web and trying it out:

http://www.devcity.net/net/article.aspx?alias=msaccess_sp

It works fine. However, I do not see anything when I look
under Queries tab in MS Access. It seems to be hidden
somewhere and doesn't want to show itself.

 

[Joe Fallon]

Looks like you skipped this part of the article:

"Unlike other objects in Access, stored procedures have no interface and
cannot be created or run through the Access User Interface. The way to get
them into your database is to simply code them."

 

[aaa]

thanks joe. i would not have realized this. i guess i got
confused because i did see a SP tab when I tried to create
an Access Project(new or existing database). I guess that's
what confused me.

 

[Joe Fallon]

Yep.
Access Projects connect directly to SQL SERVER so you get to use that
functionality.

The article was talking about the JET database engine (v 4.0) which added
this functionality to JET databases.