ODBC Driver Path Error (1 Viewer)

rsACC99

New member
Local time
Today, 12:09
Joined
Feb 3, 2011
Messages
4
My Office 2019 spreadsheets get tables & queries from Access. Sometimes, when i want to refresh connections the error "ODBC Microsoft Access Driver 'C:\...' is not a valid Path. Make sure the path name is spelled correctly..." occurs. The path the error references was the correct path on my old XP PC. On the new Win 10 PC the path is different. I have looked through all the properties of all the connections and only find the correct path. There are several *.ODC files in a folder called \My Data Sources. Opening them in Notepad reveals only text referencing the correct path, not the old, error causing path. How might I track down the invalid path and change it? (hope this is the right forum) -Thanks!
 

AccessBlaster

Registered User.
Local time
Today, 11:09
Joined
May 22, 2010
Messages
5,911
Can you open Access and run the linked table manager, and re-link to Excel?
 

Users who are viewing this thread

Top Bottom