Access paradox

[FERNANDO]

Hello,

I am trying to get access to an administration program
data bases. The manual inidcates that these are in paradox
format (*.db). When I try to open/import one of the files
with either MS Access or MS Excel, the following error --however, I really need to make this connection with VB
from MS Excel, and I tryied the following:

'// Some code......

Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
DataBaseName & ";"

'// More code......

and I get -->> Unrecognized database
format 'C:\......\FileName.db' <<--

Is this the correct method to access a paradox data base?

Help would be much appreciated

Fernando
Mexico

 

[Harald Staff]

Hi Fernando

No, you are addressing the Access Jet driver, not the Paradox driver (which
may or may not be installed, it's a little awkward that one). Start at
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForParadox
and see if you can find anything there and in its links.

 

[onedaywhen]

Unlikely, because you are using the Microsoft OLEDB provider for Jet.
You should be using a driver for Paradox e.g.

oConn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence=ASCII"

(Source:
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForParadox
)

--