Dbase III Question

[Mithyrl]

I am currently working on a project that uses a DBase III database. So far I have only used Access database and I am unsure how to connect to one.

Does anyone have any good connection strings? Can you use Jet with a DBaseII database or so you have to use ODBC?

I will also be needing to print out reports with this database...I was trying to use a DataEnvironment with a DataReport but so far I have had no luck.

I Have been trying to use a SHAPE command to build a hierarchy so I can use groups...I have been successful using an Access database doing this but I keep getting errors such as :

[Microsoft][ODBC dBase Driver] Too Few Parameters. Expected 1.

I wish I could could switch over to an access database it would be so much easier but I am stuck :(

Anyone have any suggestions?

[Clunietp]

you can connect with ADO this way


'uses ADO 2.1 or higher (Jet 4)
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection

'open connection to FOLDER with DBF file
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDirWithData\;Extended Properties=DBase III"

'name of DBF file here
Set rs = cn.Execute("Select * from Customers")


MsgBox rs.Fields(1).Value

cn.Close

Set cn = Nothing