troubleshooting Question

Access 2013 Query seems to cache first run/wont update

Avatar of kwoznica732
kwoznica732 asked on
Microsoft AccessMicrosoft SQL ServerSQL
5 Comments1 Solution790 ViewsLast Modified:
I have created a query in access that provided results of 5 fields. There are also 2 parameters set on the date field to choose a date range, Between [Start Date] and [End Date].

When I run the query for the first time it works and provides the result set based on the date range.

If I then add records to the database and they are committed. Then run the same query with a date range based on the new records no results are returned.

If I delete the query and rebuild it the same way and run it, the results I entered from the update appear.

I have no filter on the query other than the parameters.

It seems as if the query is caching the results from that first run and I don't know why. Can anyone offer a suggestion as to why this might happen?

Below you will find the sql code from access for the query.
PARAMETERS [Start Date] DateTime, [End Date] DateTime;
SELECT dbo_NonConfData.CaseDate, dbo_NonConfData.Id, dbo_NonConfCreator.CreatorName, dbo_DefectCategory.DefectCatType, dbo_Vendor.Name, dbo_NonConfData.OrderNum
FROM ((dbo_NonConfData INNER JOIN dbo_NonConfCreator ON dbo_NonConfData.Creator = dbo_NonConfCreator.ID) INNER JOIN dbo_Vendor ON dbo_NonConfData.ProducedBy = dbo_Vendor.ID) INNER JOIN dbo_DefectCategory ON dbo_NonConfData.DefectCategory = dbo_DefectCategory.ID
WHERE (((dbo_NonConfData.CaseDate) Between [Start Date] And [End Date]))
ORDER BY dbo_NonConfData.CaseDate;
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros