Duane,
Thanks for your reply. I don't know the difference between a pass-through query and an Access query. Nor do I know which tables might need to be queried so I don't really know how I would set that up with a form. I was wondering if an ODBC connection might be able to be made read only of if the links to the tables could be made ready only. Then I could give him a database and let him write his own queries.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom wrote:
>
> 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@...
> >
> > 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 (3) |
Tidak ada komentar:
Posting Komentar