ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Refresh MSQuery w/ Access datasource issue (https://www.excelbanter.com/excel-discussion-misc-queries/96791-refresh-msquery-w-access-datasource-issue.html)

Chris B

Refresh MSQuery w/ Access datasource issue
 
I have a user who has created and Excel spreadsheet that grabs data from an
Access database via ODBC. This had been working fine, but recently everytime
he tries to refresh the query, it takes a very long time to refresh the data,
which used to not be the case. He can take the Excel/ODBC to a different
computer and it runs fine. I suspect an ODBC issue, but we've recreated the
ODBC driver and updated the spreadsheet to reflect that to no avail.

Any ideas?
--
Chris Burke

Nick Hodge

Refresh MSQuery w/ Access datasource issue
 
Maybe a screwed network profile?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Chris B" wrote in message
...
I have a user who has created and Excel spreadsheet that grabs data from an
Access database via ODBC. This had been working fine, but recently
everytime
he tries to refresh the query, it takes a very long time to refresh the
data,
which used to not be the case. He can take the Excel/ODBC to a different
computer and it runs fine. I suspect an ODBC issue, but we've recreated
the
ODBC driver and updated the spreadsheet to reflect that to no avail.

Any ideas?
--
Chris Burke





All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com