If you create a pass through query, say:
Select *
From tblMSSQL
and name it ptSQL
you can then call that query from another access query and/or query wizard - such
as:
Select *
From ptSQL
That's one of the best things about Access - one query can easily call another
so you can build complexity one step at a time
ahlii@hotmail.com (Freelobly Li) wrote in message news:<17637d5c.0311100210.2c89085a@posting.google. com>...[color=blue]
> Actually the database is given for a semi-technical user to use that
> his level of query technique is just up to building simple query. It
> is not exepected that he is able to build any pass through query. So I
> just want to find out if client side cursor is possible to use so that
> the result set is downloaded to Access first so that no table locking
> is done.
>
>
MeadeR@ComputerSOSNJ.com (MeadeR) wrote in message news:<32684913.0311031303.27b7377@posting.google.c om>...[color=green]
> > Not sure I can help with the first question - without access to the
> > tables, etc.
> > The second one - if you create a pass through query to the MS SQL
> > table you will not lock the table as you browse. Directly linking to
> > the MS SQL table will cause significant locking/performance issues on
> > SQL Server
> >
> > "Freelobly Li" <ahlii@hotmail.com> wrote in message news:<bo526j$s21$1@hfc.pacific.net.hk>...[color=darkred]
> > > Hi all, I have encountered two problems when using linked tables; the linked
> > > table is connected to SQL server 2000.
> > >
> > > 1) How can I add the N prefix of a string constant in a query in order to
> > > search for double byte characters? I found that the search returns no result
> > > if no N prefix is added. If I use passthrough query, it works. Any
> > > suggestion if I do want an access select query instead of passthrough query
> > > in this case?
> > >
> > > 2) There will be a table locks in the SQL server if I browse a link table
> > > directly. Is there any possible way such that the cursor if at client side
> > > instead of server side so that no table is locked if I browse a table? Thx!![/color][/color][/color]
