Link table with SQL Server 2000 problem

  • Thread starter Thread starter Freelobly Li
  • Start date Start date
F

Freelobly Li

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 is at client side
instead of server side so that no table is locked if I browse a table? Thx!!
 
1. If you are referring to the ntext data type, then Access doesn't know
anything about this. Maybe try basing the Access Query on a SQL Server
view.

2. You can create an ADO disconnected recordset, and bind it to the form.
See the Recordset property of a form.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top