Two Linked Table Problem

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!!

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=blue]
> 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]

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=blue]
> 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=green]
> > 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]

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]