Dim myConn As New System.Data.Odbc.OdbcConnection("Driver={Microsoft dBASE Driver (*.dbf)};Dbq=c:\") Dim myCmd As New System.Data.Odbc.OdbcCommand("CREATE TABLE test (filename varchar(240) Unique)", myConn) myConn.Open() myCmd.ExecuteNonQuery()And it errors out because it can only index a field up to 100 length. In foxpro 9, unique fields can be indexed up to 240 length. I really need this field to be above 200 length and be indexed. Is there any workaround?