p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Stored Procedures


Message #1 by "Andrew Cooper" <aecooper@i...> on Tue, 12 Jun 2001 09:08:45 -0400
Greetings,



	I'm new to the list so salutations.  I've been reading and attempting to

work through Wrox's VB Web Programming book and one of the case studies is

building a Web Message Board.  The application uses SQL Server as the

database and all the data manipulation is done on the server via stored

procedures.  Can I do the same thing is Access?  I'm not going to be able to

have SQL Server on my website and need to use Access.



Thanks for any help,



Andrew Cooper

Systems Integrator

Innovative Controls, Inc

aecooper@i...



Message #2 by tony.scott@n... on Tue, 12 Jun 2001 17:36:35

Andrew,



  I cannot explain from the Web Page view, but I can explain what a Stored 

Procedure is, and it's use.



  A stored Procedure is simply a Server-side Query. The reasons we use 

such SPs is because when completing long, involved data manipulation, it's 

faster (and uses less resources) to complete the task on the Server alone, 

rather than using network traffic to request the data from the server to 

the client, complete the calculations on the client side and then send it 

back to the server again. Also we can complete more involved and complex 

tasks on the server alone.



  Therefore in conclusion, and as I said I cannot advise concerning Web 

paging, you could refer to an Access Query the same way as you would a 

Stored Procedure.



Hope this assists somewhat



Tony





> Greetings,

> 

> 	I'm new to the list so salutations.  I've been reading and 

attempting to

> work through Wrox's VB Web Programming book and one of the case studies 

is

> building a Web Message Board.  The application uses SQL Server as the

> database and all the data manipulation is done on the server via stored

> procedures.  Can I do the same thing is Access?  I'm not going to be 

able to

> have SQL Server on my website and need to use Access.

> 

> Thanks for any help,

> 

> Andrew Cooper

> Systems Integrator

> Innovative Controls, Inc

> aecooper@i...

> 

Message #3 by "Andrew Cooper" <aecooper@i...> on Tue, 12 Jun 2001 12:49:38 -0400
Tony,



	Thanks.  That's what I needed to know.  The Access Query is the equivilent

of the SQL Stored Procedure.  Does it use the same language commands, such

as CREATE PROCEDURE, BEGIN, END... and the rest or does it have its own

proprietary reserved words?  I hope I don't sound too stupid. :)



Andrew



-----Original Message-----

From: tony.scott@n...

[mailto:tony.scott@n...]

Sent: Tuesday, June 12, 2001 5:37 PM

To: Access

Subject: [access] Re: Stored Procedures







Andrew,



  I cannot explain from the Web Page view, but I can explain what a Stored

Procedure is, and it's use.



  A stored Procedure is simply a Server-side Query. The reasons we use

such SPs is because when completing long, involved data manipulation, it's

faster (and uses less resources) to complete the task on the Server alone,

rather than using network traffic to request the data from the server to

the client, complete the calculations on the client side and then send it

back to the server again. Also we can complete more involved and complex

tasks on the server alone.



  Therefore in conclusion, and as I said I cannot advise concerning Web

paging, you could refer to an Access Query the same way as you would a

Stored Procedure.



Hope this assists somewhat



Tony





Message #4 by "WebSource" <websource@p...> on Tue, 12 Jun 2001 12:56:58 -0700
Andrew, there is a very good description of this pocedure in "Begging ASP

Databases" by John Kauffman.  It also is a WROX book.

Mike

----- Original Message -----

From: <tony.scott@n...>

To: "Access" <access@p...>

Sent: Tuesday, June 12, 2001 5:36 PM

Subject: [access] Re: Stored Procedures





>

> Andrew,

>

>   I cannot explain from the Web Page view, but I can explain what a Stored

> Procedure is, and it's use.

>

>   A stored Procedure is simply a Server-side Query. The reasons we use

> such SPs is because when completing long, involved data manipulation, it's

> faster (and uses less resources) to complete the task on the Server alone,

> rather than using network traffic to request the data from the server to

> the client, complete the calculations on the client side and then send it

> back to the server again. Also we can complete more involved and complex

> tasks on the server alone.

>

>   Therefore in conclusion, and as I said I cannot advise concerning Web

> paging, you could refer to an Access Query the same way as you would a

> Stored Procedure.

>

> Hope this assists somewhat

>

> Tony

>

>

> > Greetings,

> >

> > I'm new to the list so salutations.  I've been reading and

> attempting to

> > work through Wrox's VB Web Programming book and one of the case studies

> is

> > building a Web Message Board.  The application uses SQL Server as the

> > database and all the data manipulation is done on the server via stored

> > procedures.  Can I do the same thing is Access?  I'm not going to be

> able to

> > have SQL Server on my website and need to use Access.

> >

> > Thanks for any help,

> >

> > Andrew Cooper

> > Systems Integrator

> > Innovative Controls, Inc

> > aecooper@i...

> >

>




>

>




  Return to Index