Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problems running stored procedure (2003)

    I appear to be getting an error when trying to run a stored procedure from within a macro, see attached for error.
    Any help would be appreciated.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Problems running stored procedure (2003)

    Do you have a SP called testy? How are you connecting to the SQL server - is this an ADP?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems running stored procedure (2003)

    Hello,

    I am sorry please can you explain in more simple terms? , What is SP , l don't use SQL server?

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Problems running stored procedure (2003)

    SP = stored procedure.
    If you don't use SQL Server, what database do you have the stored procedures in?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems running stored procedure (2003)

    See attached for details of the database which the procedure called
    Attached Images Attached Images

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems running stored procedure (2003)

    if you want to quit Access after a macro has run, you can add 'quit' to the bottom of the macro stack. No need to get into VBA for that.

Posting Permissions

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