Hi



I've only just started learning about Stored procedures and was wondering

how, if possible at all, to include them in an Access databases.  Would

there be any advantages (except for 'tidying' code) to have stored procs. in

an Access database?



Also - could I then export the MS Access database to something like MSDE?



Thanks in advance,



Ben Smith



E-Mail: ben@b...

Unless I'm mistaken, stored procedures are the same as queries in an

access database.  SQL Server usually calls them Stored Procedures

whereas Access calls them Queries.  



They are helpful on Active Server Pages because you can pass a single

paramater required by the DB instead of building a big SQL string.



This can tidy up your ASP code quite a bit. 



Mitch



---- Original Message ----

From: ben@b...

To: access@p..., 

Subject: RE: [access] Stored Procedures In Access Databases

Date: Fri, 09 Feb 2001 19:01:58 -0800



>Hi

>

>I've only just started learning about Stored procedures and was 

>wondering

>how, if possible at all, to include them in an Access databases.  

>Would

>there be any advantages (except for 'tidying' code) to have stored 

>procs. in

>an Access database?

>

>Also - could I then export the MS Access database to something like 

>MSDE?

>

>Thanks in advance,

>

>Ben Smith

>

>E-Mail: ben@b...

>

>

Access 2000 contains a new feature called Access Data Projects (ADP). ADPs allow you to build Access
front-ends for client/server backends. You can connect your Access forms and reports directly to SQL Server 7.0/MSDE, which stores
your tables and stored procedures. OLE DB and ADO replace the Jet 4.0 database engine. Stored procedures in ADP replace conventional
Access action and parameter queries.



ADP aren't stored in regular .mdb files, but in .adp files. Check out the NorthwindCS.adp sample project that ships with Access 2000. First, install MSDE on your local computer. When you open NorthwindCS.adp, VBA code in the Startup module starts MSDE for you, if it isn't already running, and places your tables, views, database diagrams and stored procedures on MSDE. Your forms, reports, data access pages, macros and moules remain in you front-end application. Great way to get a feel for client server computing without all the extra hardware. Enjoy.