Stored Procedure not shown ?

M

Mary

I am using Access 2003 and have created a ADP connected to
a SQL Server.

I find that all stored procedures / views are under the
category of Query in Access. Is it possible for me to
have different categories - like: Stored Procedure and
Views and User Defined Function ?

Thank you for your help
 
A

Allen Browne

Using the ADOX library you can distingish views and procedures:

Function ShowProx()
Dim cat As New ADOX.Catalog
Dim proc As ADOX.Procedure
Dim vw As ADOX.View

cat.ActiveConnection = CurrentProject.Connection

Debug.Print "Procedures: " & cat.Procedures.Count
For Each proc In cat.Procedures
Debug.Print proc.Name
Next
Debug.Print cat.Procedures.Count & " procedure(s)"
Debug.Print

Debug.Print "Views " & cat.Views.Count
For Each vw In cat.Views
Debug.Print vw.Name
Next

Set cat = Nothing
End Function
 
Top