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 |
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