>Ok I changed it to this for testing:
>
>Dim myCmd As New System.Data.OleDb.OleDbCommand("CREATE TABLE test (filename varchar(100) Unique)", myConn)
>
>
>However it errors when I try to raise the length of the field above 100, whereas in foxpro I could take it to 240. Is this a limitation of the driver Im using? If so, what other tables could I use to get to 240 with an index?
Sorry Rhys,
I have no idea. I just know that if you didn;t install latest OLE DB driver for VFP you can't use new field types :-(
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.