Create Table "test.dbf" (filename v(240) Unique, Date v(50) Null)The test.dbf is not part of a dbc. So far I have converted it to this:
Dim myConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=dBASE IV;User ID=;Password=") Dim myCmd As New System.Data.OleDb.OleDbCommand("CREATE TABLE test.dbf (filename varchar(240) Unique, Date varchar(50) Null)", myConn) myConn.Open() myCmd.ExecuteNonQuery()It gives me the error "Syntax error in field definition". What is the correct syntax? Also, the unique field obviously speeds up scans alot because of the cdx index, but will vb.net automatically create this index? I need to use a table that wont require a driver that does not come with a clean install of win2k, so I figured a dbf would be the fastest.