Link to Paradox from Access

[Timbo]

Hi, I'm struggling to link to some old Paradox tables from Access. Some do,
some don't. Seems to be the '8.3' file naming problem, which shouldn't be a
problem as I'm using Access 2003 with XP SP2, which should mean I'm on Jet
Engine 4.0 SP 8. However, when I check out Office Components in System Info,
I seem to be using Jet 3.5 - I can find files for both Jet 3.5 and Jet 4.0 on
my system.
How can I FORCE Access to use the latest version of the Jet Engine - I'm
hoping this will fix my Paradox problem.

 

[Pat Hartman\(MVP\)]

Go to Tools/References from the VBA window and change the library that is
selected or just give up and rename the files to conform to the 8.3 style.