Use pass-through queries. You can take the input values from controls on a form and build the SQL statement. Make sure the SQL statement is SQL Server appropriate and change the SQL property of a saved pass-through. Then display the results of the pass-through in a datasheet subform.
Duane Hookom MVP
MS Access
----------------------------------------
> From: winberry.doyce@roadsysinc.com
>
> Hello friends,
>
> I need some advice. I have a new user that is fairly good with Access that would like to be able to run Access queries off of our MRP system with linked tables to an SQL Server backend. However, he and I both prefer to make it read only so no data gets changed. What is the best approach to take for this?
>
> Doyce
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar