Bill,
I've done this and it works as I want with one exception. The first time it makes the connection it asks the user for the password. Is there a way around this? I put in the password in the DSN.
Doyce
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" wrote:
>
> Doyce
>
> Duane's suggestion to create a Login is the best way to go. Be sure to use SQL Server Authentication instead of Windows Authentication so you don't over-write permissions that the user will need when using your application.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "dnwinberry" wrote:
> >
> > Thanks again Duane. I found a tutorial that shows how to setup a pass-through query. I'll try it out and see what happens.
> >
> > Doyce
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom wrote:
> > >
> > > Doyce,
> > >
> > > Create a SQL server login that has db_DataReader and db_DenyWriter roles in the database(s). Then use this login to link to the SQL Server tables.
> > >
> > > A pass-through query is typically much more efficient in querying data from SQL Server. There is no possibility of editing data in a SELECT pass-through query. The p-t has a connection property that identifies how to get to the SQL tables/views.
> > >
> > > Duane Hookom MVP
> > > MS Access
> > >
> > > ----------------------------------------
> > > > From: winberry.doyce@
> > > >
> > > > 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 (8) |
Tidak ada komentar:
Posting Komentar