this is how i do it: with db.table1 do begin open; first; for i := 1 to recordcount do delete; close; end; table1 has a corresponding index table1.mdx by the method im using..will it also autmatically update the mdx file?