I am still learning how to use DAO 3.51 and I am trying to <br>
connect with a paradox db. Has anyone tried doing this?<br>
<br>
Here is what I have...<br>
Set wrkJet = CreateWorkspace("NewJetWorkspace", "admin","", dbUseJet)<br>
Set db = wrkJet.OpenDatabase("c:\legiwin\paradox.mdb")<br>
Set td = db.CreateTableDef("LinkedTable") td.SourceTableName = ("Table1")<br>
With td <br>
.Connect = "Paradox 4.X;DATABASE=C:\Legiwin\BCA.db;win32=<path>\MSPDOX35.dll;ParadoxNetPath=c:<br>
\legiwin;PageTimeout = 600;ParadoxNetStyle=4.X;DataCodePage = <br>
OEM;CollatingSequence = ASCII" <br>
End With <br>
db.TableDefs.Append td<br>
<br>
I get a run-time error saying that my path is invalid for my <br>
database. This blows my mind because it IS there.!!
connect with a paradox db. Has anyone tried doing this?<br>
<br>
Here is what I have...<br>
Set wrkJet = CreateWorkspace("NewJetWorkspace", "admin","", dbUseJet)<br>
Set db = wrkJet.OpenDatabase("c:\legiwin\paradox.mdb")<br>
Set td = db.CreateTableDef("LinkedTable") td.SourceTableName = ("Table1")<br>
With td <br>
.Connect = "Paradox 4.X;DATABASE=C:\Legiwin\BCA.db;win32=<path>\MSPDOX35.dll;ParadoxNetPath=c:<br>
\legiwin;PageTimeout = 600;ParadoxNetStyle=4.X;DataCodePage = <br>
OEM;CollatingSequence = ASCII" <br>
End With <br>
db.TableDefs.Append td<br>
<br>
I get a run-time error saying that my path is invalid for my <br>
database. This blows my mind because it IS there.!!