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

Posted on 2011-05-09
Medium Priority
Last Modified: 2012-05-11
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)?
Question by:Voodoo_chile
LVL 42

Accepted Solution

dqmq earned 500 total points
ID: 35726310
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.    


Author Closing Comment

ID: 35828270
This solution confirms I have to use passthrough query in code.

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question