Pass through query slow until I change search criteria

[Jayce72]

I have an access 2007 database connect to sql server 2008.

I am running a pass though query to search between two dates (this query has been fine for years)

If I now run any search using parameters from 26th March 2014 to date - the query takes 10+ minutes to run.

If I then change the date to 25th March 2014 to date - it runs in a nano second.

I have not changed the back tables and I have not changed the format the data is saved in.

I'm stumped - please help

 

[Galaxiom]

That is seriously weird.

Does the same thing happen when you run the query in SSMS on the server?

 

[Jayce72]

I don't have direct access to sql server, but I do have a mirrored environment on a standalone laptop. When I run the same query directly in sql query - it's fine!!

If I try and use a plain access query - there are so many records it takes forever anyway - hence I've always used a pass through.