Results 1 to 3 of 3

Thread: sql

  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sql

    I am not sure this is an appropriate question but I am totally confused. I am fronting a SQL database with access. When I go into the the SQL database I can't see the user stored procedures only the system SP. I am able to run the user SP from access. This is the only SQL database I ever designed and that was over 2 years ago. I just can't remember what I am suppose to do and I have spent to much time googling this.

    Thanks for any help you might be able to give me.

    Cathy

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sql

    Hi Cathy

    The day I leave my SQL books at work is today <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    The simple answer is you cannot view the stored procedures from Access but you can call from the database. I have hunted around the web and feel this is quite a good tutorial and although 3 years old is very good.

    http://www.databasejournal.com/features/ms...cle.php/3407531

    I hope this helps?
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sql

    Jerry
    The problem turned out that I had to register my network copy of the database. I was looking at my local copy. It was driving me crazy.

    Thanks I appreciate your time.
    Cathy

Posting Permissions

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