Help needed here!
I've got a system made out of: Access front-end + SQL Server back-end (typical).
I need to call from Access VBA a function in SQL Server, but I can't get it to run, some detail is missing. Say the SQL function is called XFunc(@id INT), so it has one parameter @id.
The ADODB code then would look sth like:
Dim cmd as NEW adodb.command
cmd.activeconnection = <the connexion you've set up>
cmd.CommandText = "XFunc"
cmd.Parameters = ??????????
I've tried this but VBA throws an error, either I'm missing the parameter @id when calling XFunc, or there is a specific ADODB command to call function (and maybe I'm using the stored procedures one).
What am I missing here? Are there any good sources of ADODB documentation you can recommend?
Thanks in advance, A.