keepITcool wrote ...

edit it in MsQuery..
THEN in SQL mode you can see the table..

I tried this myself and the text in the SQL window was as follows:

{Call MyStoredProc('2001-01-01', '2004-01-01')}

Do I now have to query a system table? Something like:

Dim oConn As Object
Dim oRs As Object

Set oConn = CreateObject("ADODB.Connection")
With oConn
.CursorLocation = 3 ' adUseClient
.ConnectionString = CONN_STRING
.Open

' adSchemaProcedures
Set oRs = .OpenSchema(16, _
Array(Empty, Empty, "MyStoredProc", Empty))

oRs.ActiveConnection = Nothing
.Close

End With

MsgBox oRs!PROCEDURE_DEFINITION

complicated isn't it?

Things aren't always straightforward <g.

Jamie.

--