Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security for Viewing MS Access Databases From Excel Datasource | Excel Discussion (Misc queries) | |||
Ridirect & Refresh data from access database | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Importing from Access issue | Excel Discussion (Misc queries) | |||
Link Access query to refresh an EXCEL file | New Users to Excel |