Using VFP 6.0, I want to retrieve data from an Access 97 database. I created the Connection and a remote view which works beautifully on my development machine.

However, when I install the exe on a clients machine (Windows 2000) and attempt to run it, we get the error 1526 "Connectivity error [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified."

In the Setup Wizard, I checked ODBC drivers to be included but obviously we are missing something. Anybody have an idea?