I'm using 2010 and have a database formatted .accdb but it is nothing but linked tables to a SQL database. Been using it for years and never seen this unique set of symptoms. I have a query that when run by itself to just view the data on screen runs instantly and shows all the results - which are only a few hundred records. (Not the same as restricting the preview to only a 100 records.) What I'm trying to say is that the query processes through all the database records and returns the results which are only a few hundred records in a matter of seconds.
If I run the same query to export to excel with the same criteria - the few hundred records takes 10-15 minutes to export.
If I feed the query to a report and preview the report it again runs slow - taking the same 10-15 minutes to finish running and appear on the screen.
I have googled for this phenom and didn't find anything helpful. I have searched in three sections of this forum: Access, Import/export and queries. Yes I get a lot of threads but again nothing with this weird combo of fast query that slows for export or reporting.
Thanks for any ideas.