I have an Access 2003 application that reads several Paradox files from an external application (Timeslips). I'm now having to upgrade to Access 2007 and it is not able to link to any of the same paradox tables that Access 2003 used effortlessly.
I get the error message:
"External table is not in the expected format"
when trying to link from Access 2007.
What's the best way to resolve this issue? I've done several searches and usually get sent to http://support.microsoft.com/kb/230126
which talks about Jet 4.0 SP8 -- but there's no reference to Windows 7 (my system) and for Vista they simply say "you have the latest version".
They also mention the Borland Database Engine (BDE), but I can't find a useful download location (there are lots of places where it's referenced, but most of them seem to contain attack code so are not safe to use).
Any suggestions? I've got a client waiting for this upgrade.