Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


slow pass-through query, runs quick in sql server

slow pass-through query, runs quick in sql server

slow pass-through query, runs quick in sql server

Hey all,

I'm having a strange problem with a particular pass-through query from Access 2003 to SQL Server Express 2005 suddenly running very slow. It's a stored procedure which I can get to run in about 5 seconds directly on SQL, but it takes at least 3 minutes to run the exact same query via a pass-through query in Access. The problem also started suddenly a few weeks ago, it was running from Access in about 6 seconds until then.

I have many other pass-through queries in the database which are fine and run at normal speed. I have tried creating a new pass-through and running the same query with the same result. The same thing happens on my test machine at home and all the workstations at my client. As far as I'm aware there have been no changes to drivers or versions of Access (they run a combination of 2000, 2003 and Runtime 2007 on their workstations, all having the same problem.)

Any ideas would be greatly appreciated!

RE: slow pass-through query, runs quick in sql server

do you have an index on the table that is being queried?


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close