Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Europe
    Posts
    14

    Question Unanswered: Running SP from Access 2000 with using SP owner qualifier

    Hi there,

    Can anyone tell me how to call a SQL Server Stored Procedure from an MS Access form with having to use the owner.spname style. I just want to call spname from my form.

    I know it has to do with user permissions and roles, but no matter what I do I have to still use the owner.spname style.

    Thanks,
    Brian.

  2. #2
    Join Date
    Feb 2003
    Posts
    109

    are you using ADP?

    are you using ADP?

    if you're not, move it to ADP-- it is an awesome platform.

    (ADP handles SP a lot better than MDB)
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  3. #3
    Join Date
    Jan 2003
    Location
    Europe
    Posts
    14

    Re: are you using ADP?

    Thanks for the suggestion Aaron, but I am using ADP and it's Access 2000.

    I think the issue is on the server side with SQL Server, but one of the lads working (same privileges apparently) with me doesn't have this issue ... it's weird and greatly annoying.

    Cheers ....

  4. #4
    Join Date
    Feb 2003
    Posts
    109

    instead of dealing with buggy input parameters

    instead of dealing with buggy input parameters i usually just use this syntax in the recordsource property of an ADP form or report:

    EXEC sp_colums 'sysobjects'

    is that what you're looking for?
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  5. #5
    Join Date
    Jan 2003
    Location
    Europe
    Posts
    14

    Thumbs up Re: instead of dealing with buggy input parameters

    That works a treat Aaron, thanks a mill. Now life is just so much easier

Posting Permissions

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