I am trying to call a function in SQL Server 2005 from Access 2003. It works fine with the constant value, but fails with a variable of the same value. This works:
strSQL = "SELECT * FROM functionName (constantValue)"
rs.Open strSQL, cn
when I use variable in the parameter, I get error. I have tried creating parameter objects in Access, but couldn't execute it and don't know if this is a way to go anyway.
Would appreciate for any help or suggestion.
View Complete Post