List of stored procedures in Access

Chals

Hello, Is there any way to get a list of stored procedures in an MS Access database? Been searching for a while and found nothing :( Thanks in advance

cobyjone

Create a view in sql server around the following sql statement and select out of the view in access: select name from dbo.sysobjects where xtype = 'P' and status >= 0 and name not like 'dtp%' order by name

Chals

Excuse my ignorance, but how am I supposed to create a view in sql server working with MS Access? Could you be more explicit please? Thanks

cobyjone

Create a view using query analyzer. Grant select to public. Then access it via a function in vba or directly with a linked ODBC data source. sql: Create View storedproclist as Select name From dbo.sysobjects Where xtype = 'P' and status >= 0 and name not like 'dtp%' Go Grant Select On storedproclist To Public

J4amieC

Access doesnt have stored procedures, it has queries and I dont think there is a built-in way of enumerating them.

Chals

Actually, since Access 2000, it does support stored procedures, you can create them through OleDbCommand objects. Problem is there seems to be no way of listing them, unless our cryptic friend's solution works. I yet have to try it.