Unanswered: Clear cache/disable caching of Access Queries
I have a problem that really annoys me, I hope you can help me.
I have a Access front-end with a form that has a complex query as a recordsource. Despite the query being made from of cca 10 joined other queries (various join types, linked tables & select & crosstab queries) the query doesn't take more than a second to requery. However... when I modify data in one of the underlying tables by SQL command through VBA, the query returns the results prior to that change and will start returning the correct results only after 2-5 seconds.
This behaviour is very strange to me, my guess is that the query stores some cache that has a certain life-span and the engine decides to use the cache if it isn't too old rather then refresh the query.