Professional Web Applications Themes

MS Access Report Can't Find Stored Procedure - Microsoft SQL / MS SQL Server

I have a MS Access 2000 front end application accessing a MS SQL 7 database via ODBC. The application calls many stored procedures in the database. I have a new report and new stored procedure as the source data for the report. Some users accessing the report via a Windows 2000 Terminal Services session get a report failure message indicating the stored procedure cannot be found. When I access the report, either locally or via Terminal Services, the report works fine. I believe this is a rights issue since it works for me and not for my remote users. I ...

Sponsored Links
  1. #1

    Default MS Access Report Can't Find Stored Procedure

    I have a MS Access 2000 front end application accessing a
    MS SQL 7 database via ODBC. The application calls many
    stored procedures in the database.
    I have a new report and new stored procedure as the source
    data for the report. Some users accessing the report via
    a Windows 2000 Terminal Services session get a report
    failure message indicating the stored procedure cannot be
    found. When I access the report, either locally or via
    Terminal Services, the report works fine.
    I believe this is a rights issue since it works for me and
    not for my remote users. I have granted full rights in
    the database to the remote users for this stored procedure
    but the result is the same.
    Any Ideas? Please help.
    Sponsored Links
    Michael Guest

  2. #2

    Default Re: MS Access Report Can't Find Stored Procedure

    Make sure that the owner of the SP is 'dbo'.
    If a non sysadmin login has created the SP, it will have the DB username of
    that login as the owner.
    If your users use different logins and access the SP using it's object name
    only, SQL will look for a SP with their usernames as owners.
    You can either change your app. to use a 2 part name (owner.object) but that
    would make life harder for you and also break ownership chains.
    If you have sysadmin rights, simply use sp_changeobjectowner to transfer
    ownership of the new SP to dbo.
    MS recommends that dbo should own all objects.

    HTH

    "Michael Wolfstone" <com> wrote in message
    news:01f801c365c0$1d048eb0$gbl... 


    Amy Guest

  3. #3

    Default Re: MS Access Report Can't Find Stored Procedure

    Thanks, that did the job.



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Michael Guest

Similar Threads

  1. MS Access Stored Procedure
    By Roland Hall in forum ASP Database
    Replies: 4
    Last Post: January 31st, 07:05 PM
  2. [SQL 6.5] Cannot access temporary tables from a stored procedure
    By beyond in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 6th, 06:37 PM
  3. URGENT Access Stored Procedure Help
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 17th, 06:50 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139