Unanswered: How do you pass parameters to a stored procedure when executed from an Access macro?
While converting an existing Access 2000 application to ADP using a SQL 2000 back end, I came across multiple macros that were attempting to execute queries. The queries have been converted to stored procedures in the SQL database but when you change the macro to execute the stored procedure, there is no place to enter the required parameters (i.e. Input Parameters). What's the best way to resolve this without recoding all the macro logic?
Originally posted by Aavarn Not 100% but can't you put the variables in in comma seperated form after the sp-name?
SP_YourSP, var1, var2, var3
Unfortunately, Access 2K will not allow arguments on the same line as the procedure name in a macro. It replies with an error that it "can't find the object". I've tried different variations on the syntax with no success.
This seems like an Access ADP limitation which will probably be corrected in the next release or service pack. I can replace the macros with VBA code but that may take too long given the number of macros involved (approx. 112) and my impending deadlines.