There seems to be some confusion about mdac (up to WinXP you definitely needed the latest version. The consensus ref. Google is that it was renamed Windows DAC and is pre-installed - however ms seem to offer it here: http://microsoftdataaccesscomponentsmdac28.10appstore.net/win10software.html
What you *do* need for VFP and VB is the correct version of ODBC - from memory you install the 32 bit version and rename it?