Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Glasgow, Scotland
    Posts
    7

    Red face Unanswered: stored procedure return value in access

    I am running a stored procedure from Access to insert a record into an SQL table which includes an identity field, the stored procedure returns the identity number assigned to the inserted record. How can I access this return value from my vba code. I am using [adodb.connection].execute to run the stored procedure.


    thanks

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Last edited by Paul Young; 03-21-03 at 14:49.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •