How to hit Paradox data from VB6

[youdao]

I am completely new to Paradox. I am not sure the exact version of the data, only know it is Paradox version 5.x or below.

First I tried ODBC, but got an error saying that I can not use Jet Engine to access an ISAM source. If you know how to use ODBC, please give me a sample statement

Dim dbsMyDB as DAO.Database
Set dbsMyDB = OpenDatabase(<How to wirte this part>)

Then, I tried to use Access 2000 to link to Paradox and then use DAO to hit it in the same way I hit Access native table. It works alright, but too slow. Is there a way to speed it up in terms of tuning index or any other trick.

Thank you for any advice.

Youdao

 

[Guest_imported]

win32 = &quot;c:\WINDOWS\SYSTEM\MSPDOX35.dll&quot; ' MS PARADOX DRIVER

Set db = OpenDatabase(drive:\TablePath, True, False, &quot;Paradox 5.x;&quot

Set recSet = db.openRecordSet(yourtable)

This code will allow you to open and use version 5 or lower paradox tables in VB. The dll file if you don't have it can be installed using office97 cd or perhaps you can get it from msdn.