I've build a sp which returns variables (instead of a recordset based on tables) to ms access.
The querydef which I declared in access has the property returnrecords set to true, but access complains that my sp doesn't return any records. Whenever I run it in the query-tool of SqlServer it returns the correct information.
Can anyone help me with this?
By the way: I use stored procedures extensivelly, but never before did it return variables.
Hope you can help,