Hi,
I have a foxpro table accessed through MS ACESS connection. My search is taking a long time. So want to include an index to the table while the form is loaded. I used the following command
Is the above statment actually index the field, ITEM_NO .Currently I am getting error "Cannot execute data definition statements on linked data sources" . Is there a constraint on creating an index on a table which already has data.Any idea?
Is there a file created with some extension when i do an Indexing? .
I have a foxpro table accessed through MS ACESS connection. My search is taking a long time. So want to include an index to the table while the form is loaded. I used the following command
VB.NET:
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\database.mdb;Persist Security Info=False")
cn.Open()
cmd = New OleDbCommand("Create INDEX itmno_idx ON INVENT (ITEM_NO)", cn)
cmd.ExecuteNonQuery()
Is there a file created with some extension when i do an Indexing? .