Linked SQL 2000 Table and Query Problem

J

jsacrey

Hey everybody, got a secnario for ya that I need a bit of help with.

Access 97 using linked tables from an SQL Server 2000 machine.


I've created a simple query using two tables joined by one field
between them. The join field in both tables are indexed and I'm
selecting 1 field from each table to lookup. The Access query is
taking more than 60 second to retrieve 1 record and if I execute the
same query within the Query Analyzer, it takes less than a second to
execute.


I've tried using the SQL Profiler to see what's being sent to the
server, but I don't see anything showing up there when I execute the
Access query. I must confess that I'm new to the Profiler, so I
might
not be looking in the correct place for the SQL that is supposedly
being processed.


Do you think that Jet is retrieving all of the records from the SQL
machine so that it can run the query locally? If so, is there a way
for me to see this activitiy within the SQL Profiler?


Thanks for any insight you can provide,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Append Crosstab Query to Existing Table 0
Doughnut Chart linked with the slicer in the pivot table 0
Embedded Excel into Word with Tables 0
Closing filtered query 0
Subquery Correllated In Select Clause - Is this possible? 3
bitwise operator in SQL 3
Linked Table Cant Delete Record 2

Top