I'm retrieving external data from Access using Microsoft Query. When I run this query on my desktop all files are located on the D: drive. The query runs fine.
I then transferred the spreadsheet, mdb and query to my laptop and tried to use them. My laptop's .mdb, .xls and .dqy files are located on identical paths except it is the C: drive. I updated the paths on the saved query to C:\ etc... changing nothing else. I receive the error message "ODBC Microsoft Access Driver Log-in Failed"- "Disk or network error".
However if I create the same query from scratch on the laptop, with IDENTICAL code, the worksheet runs fine. However, if I then save the worksheet, transfer it to the desktop, the worksheet can no longer refresh the query. And I also receive the same error message.
Is excel putting code that I dont see indicating the old (wrong) path in the excel worksheet or elsewhere other than in the query I've edited?
I then transferred the spreadsheet, mdb and query to my laptop and tried to use them. My laptop's .mdb, .xls and .dqy files are located on identical paths except it is the C: drive. I updated the paths on the saved query to C:\ etc... changing nothing else. I receive the error message "ODBC Microsoft Access Driver Log-in Failed"- "Disk or network error".
However if I create the same query from scratch on the laptop, with IDENTICAL code, the worksheet runs fine. However, if I then save the worksheet, transfer it to the desktop, the worksheet can no longer refresh the query. And I also receive the same error message.
Is excel putting code that I dont see indicating the old (wrong) path in the excel worksheet or elsewhere other than in the query I've edited?
