Stored Procedures Object MikeV06 <me[ at ]privacy.net> 06.06.2006 23:12:57 Access 2003 I do not have a Stored Procedures object group on my database list. Instead all of the Stored Procedures are listed in the Queries Objects list. A couple of books I have read store a separate Object for Stored Procedures. Did that change with 2003? Thanks, Mike.

Re: Stored Procedures Object "Robert Morley" <rmorley[ at ]magma.ca.N0.Freak1n.sparn> 07.06.2006 02:29:23 As I remember it, Access 2000 had something separate for SPs, but in 2002 and 2003, they're all lumped together under Queries to be more like Access MDB files. If you really want to see them as SPs, your best bet is probably just to use the SQL Enterprise Manager and go from there. Rob "MikeV06" <me[ at ]privacy.net> wrote in message news:164m6joyfj5vp$.dlg[ at ]mycomputer06.invalid.com... [Quoted Text] > Access 2003 > > I do not have a Stored Procedures object group on my database list. > Instead > all of the Stored Procedures are listed in the Queries Objects list. > > A couple of books I have read store a separate Object for Stored > Procedures. Did that change with 2003? > > Thanks, Mike.

Re: Stored Procedures Object "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> 07.06.2006 04:50:39 Hello MikeV06, You wrote in conference microsoft.public.access.adp.sqlserver on Tue, 6 Jun 2006 18:12:57 -0500: M> Access 2003 M> I do not have a Stored Procedures object group on my database list. M> Instead all of the Stored Procedures are listed in the Queries Objects M> list. M> A couple of books I have read store a separate Object for Stored M> Procedures. Did that change with 2003? depends on what you mean by object. The object model of Access does have collection "allstoredprocedures", and another collection "allviews". In the GUI, they all are on one page "queries" - but that's just the matter of design. Vadim Rapp

Re: Stored Procedures Object MikeV06 <me[ at ]privacy.net> 07.06.2006 16:50:35 On Tue, 6 Jun 2006 22:29:23 -0400, Robert Morley wrote: [Quoted Text] > As I remember it, Access 2000 had something separate for SPs, but in 2002 > and 2003, they're all lumped together under Queries to be more like Access > MDB files. > > If you really want to see them as SPs, your best bet is probably just to use > the SQL Enterprise Manager and go from there. > Not really. I wanted to make sure I had not messed up something in my configuration when installing 2003 (I did have other issues, like macro security missing). Clicking on an sp icon takes you to EM anyway or one can always use QA. My thanks to all who responded. At least my setup is not tanked. Mike.