Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2004, 02:38 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 121
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to add a stored procedure in Access

Hi,

  I am running a simple query in Access 2002
    eg "select * from <table>" this query is stored as "QUERY1"

  I then want to process the resulting record set in a stored
  procedure - and delete certain records. ( I know this can be done
  with a more sele3ctive SQl statement but ultimately I need to
  do some more sophisticated processing in the stored proc).

  Question: can any one point me to an example of how to create s
  stored procedure in Access? I need to be able to take in the sql
  recordset, process it and return it.

TIA
Chas.
 
Old June 15th, 2004, 02:47 AM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

I dont think so that u can add stored procedure in Access

Love 4 all
 
Old June 17th, 2004, 08:13 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please explain the exact process. You may be able to use a sub-query with a combination of append/delete/update queries with some parameters.

Access does not support stored procedures, but you could use ADO, or, you could try using SQL Server MSDE if you are interested in learning. MSDE does support stored procedures.



Sal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Add new Table to Stored Procedure pallone SQL Server 2000 2 February 14th, 2007 12:58 PM
Running oracle stored procedure from access Justine Access 9 December 21st, 2006 09:36 AM
how to use stored procedure in Access hertendreef ADO.NET 1 June 3rd, 2006 03:04 AM
Trying to add a GetTaxAmount Stored Procedure attipa Classic ASP Databases 3 July 18th, 2003 03:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.