How can I define the functions and store procedure input parameters which can be linked to the controls on the forms?

I am using an ACCDB database to connect to a MS SQL Server database using an ODBC connection. I can link the tables in SQL Server. However, I can only use the functions and procedure in MS SQL Server database when using a pass-through query.  How can I define the functions and store procedure input parameters which can be linked to the controls on the forms (which is like the Build tool for normal query)?
Voodoo_chileAsked:
Who is Participating?
 
dqmqConnect With a Mentor Commented:
An ADP database is intended for that.

With an ACCDB you can run functions/procs using passthru queries or a .net connection, but you would need to populate controls in code (as in an unbound form) and that's a ton of work.    

0
 
Voodoo_chileAuthor Commented:
This solution confirms I have to use passthrough query in code.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.