• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

ODBC Driver Path Error (1 Viewer)

rsACC99

New member
Local time
Today, 03:44
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

Custom title here:
Local time
Today, 02:44
Joined
May 22, 2010
Messages
2,615
Can you open Access and run the linked table manager, and re-link to Excel?
 

Users who are viewing this thread

Top Bottom