Accessing a Paradox Table With VB

[cruzmsl]

I have got a Paradox table, probably version 3 or older, that I need to run SQL queries on via VB. What would be the best approach? I found a method to link the Paradox table to an Access DB, but this seems messy. Is there a way to run queries directly on the Paradox table?

Thanks,

db(cruzmsl)

 

[TheVampire]

I have opened paradox tables to read data from them using this:

Set DB = OpenDatabase("C:\MyDataPath", True, False, "Paradox 7.X&quot

' the last part of this depends on the version of Paradox, of course.

And then:

Set RS = DB.OpenRecordset("MyParadoxFile.db&quot

But I don't use SQL to read them, so I don't know if that will work or not.

( To invoke another thread, this is one case where databound controls won't work, because the data control cannot connect to a version 7 paradox table, but if you use pure code it will work fine. )

Robert

 

[vb5prgrmr]

you might try dao or ado since you can connect to via access. You should be able to find a paradox ODBC driver on your machine that may allow you to connect via rdo or ado.


Good Luck