Output parameters for Access 2000 stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ollie (Ollie_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 10:55:01 -0800

Is it possible to create a stored procedure for Access 2000 that has an
output parameter? I know this is possible with SQL Server but have not been
able to track down an equivilent example for Access.

If it is not possible, can anyone suggest a way of returning a value from an
insert query (e.g. the primary key of a newly created record) from Access
2000 to an calling application (e.g. ASP application).

Cheers,
Ollie

Relevant Pages

  • Connection.Execute and SQL stored procedures
    ... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
    (microsoft.public.sqlserver.odbc)
  • Return value from Stored Procedure
    ... I've posted this question on the aspnet NG where I got some useful responses but they've yet solved my problem, then I find this classic asp NG, and hopefully, someone can spot the error right away. ... I inherited some legacy ASP codes in my office. ... The original code's back-end is using the SQL Server 2000 and I am testing to use it on the Express edition. ... Here is the shorten version of the stored procedure code: ...
    (microsoft.public.data.ado)
  • Re: ASP and SQL
    ... run a stored procedure in an SQL server from a asp page. ... Is there a way to create a user on an SQL server from a ASP page, ... You will need to use an account with sysadmin privileges in order to execute ...
    (microsoft.public.inetserver.asp.db)
  • Re: @@IDENTITY in SQL server
    ... Aaron Bertrand [SQL Server MVP] wrote: ... First, use a stored procedure, second, use SCOPE_IDENTITY (I assume SQL ... And I don't know what the point of "SET NOCOUNT ... Better yet, use an OUTPUT paremeter to send the IDENTITY value back to ASP, ...
    (microsoft.public.inetserver.asp.db)
  • SQL/ASP DB Locking/updating tables
    ... MS SQL Server 2k Dev ed ... IIS 5, ASP classic. ... Now the above ASP page calls a Stored procedure before displaying some ... does some calculations involving several tables bases on the old ...
    (microsoft.public.sqlserver.programming)