I've spent the morning copying examples of this from various web sites and what works for others is not working for me. Am I missing some basic configuration in either SQL Server 2005 or Access 2002?
The stored procedure returns data where a date field is greater than a parameter. When we first started getting errors we thought it might be to do with different date formats so we changed the procedure to use DATEADD(dd,-param,GETDATE()). The parameter then becomes a numeric value and we are only looking at a few days, so we've been setting it to 3.
If we run "EXEC spname 3" in SQL Server we get a valid queryset. If we use the same code as a Pass thru query in Access, we get 'Invalid Precision for decimal data type'.
We've tried different datatypes (int, bigint, tinyint, numeric) for the variable declaration in SQL Server. We are currently using numeric. We have initialised them as 0 and as Null, and nothing makes a difference in Access. Any ideas?