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)

 

[footpad]

cruzmsl,

You're probably going to get a better answer by asking your question in a Visual Basic forum. This particular one is devoted to Corel's Paradox for Windows, a client-front end for manipulating the Paradox file format designed by Ansa and later aquired by Borland.

I have VB/Pro 6.0. In my experience, the easiest way to create a VB form to browse or update an older Paradox table (e.g. Paradox 5 or below) is to:

1. Start the Visual Data Manager from the Add-Ins menu.

2. Choose File | Open Database | Paradox | 5.0 to display the Open Paradox Database dialog.

3. Navigate to the directory containing your table, select a .DB in that directory, and then choose OK. This displays a Database Windows showing the tables in that directory and gives you an empty SQL window. It also enables the Utility menu, which is what we're after.

4. Choose Utility | Data Form Designer.

5. When the designer appears, enter a name for the form (e.g. frmMyTable), choose the table you want the form to display, select the fields you want on the form, and then choose Build the Form.

This gives you a new form that you can use to display individual records and so forth. This isn't the best way to do it from a strict perofrmance approach, however, it's the easiest one that I know. You mileage may vary, so I suggest reviewing the various Visual Basic forums on the site and posting the same question in the one that seems most relevant to database questions for your version of VB.

Hope this helps...

-- Lance

 

[ianus]

You could set up a User/System DSN in the Windows' ODBC Data Source Administrator (Add a new data source, select the Microsoft Paradox Driver (*.db) for it and specify the default directory). After that you can open the database with DAO and manipulate it as you would manipulate any other databases (i think it's the fastes way too)...