ADO Insert Problem
Posted on 2000-04-08
I am using D5 with an ADOConnection and an ADOTable on an indexed Access2000 table. Everything works great until I insert a record. Physically, the inserted record is added to the end of the dataset and it stays there until I close and then reopen the ADOTable. After it is reopened, the inserted record appears in its expected position.
Question: Do I have to close and reopen the table to reset the index or is there a better (faster) way to make inserted record appear in their proper positions?