Sage ODBC Error “cannot find all files in data path”

Saw this error when attempting to connect Excel/Microsoft Query to an installation of Sage when Sage v14 had been installed on Vista with Office 2007 (but these two programs are unrelated to the error).

If in Microsoft Query I select the listed data source for Sage then it would generate the above error. The problem was that the data source that is created by default points to the sample Sage database and not the database on the network that the company was using.

So to fix, create a new datasource and for the data path value enter the full URL to the Sage database including the ACCDATA folder (for example \\server\sage\company.000\accdata).