sql

[Cathy]

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

[Jezza]

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?

[Cathy]

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