Click to See Complete Forum and Search --> : Paradox Database connection


DAHLGRJR
January 31st, 2000, 12:48 PM
I am attempting to connect to a Paradox table using VB 6.0. Something in my code is not quite right yet and I am having trouble finding specific examples of connection to Paradox tables. I cannot seem to get past the OpenDatabase method (for multiple reasons). Does anyone have a specific example for opening a Paradox table?

public recParadox as Recordset

Dim ParadoxSession as Object
Dim ParadoxDatabase as Object

set db = DBEngine.Workspaces(0).OpenDatabase(strDBFile, 0, 0, "Paradox 3.X")

set recParadox = db.OpenRecordset(strSQL, dbOpenSnapshot)