Bill Manville wrote in message
Pity my clients are all 2002 at latest
Why?
You can *create* the procedure within MS Access using the PROCEDURE
syntax e.g. I just tested your example
PROCEDURE MyProc [argSiteID] INTEGER;
SELECT * FROM Sites WHERE Sites=argSiteID
in Access95 and it works fine and will work for all subsequent
versions of MS Access.
You can *call* the procedure within MS Query using ODBC's call syntax.
Again, tested fine in Excel95 and above.
Jamie.
--
|