>>I used both zap, and delete all, pack, and neither works. I just need to empty the file so it it can be filled with fresh, relevant data. I have resorted to using SQL select and a cursor, which I make the grid's record source, so now I don't need to empty the table anymore. I am sorry, and no offense, but zap, and delete all/pack are the only two ways I know of emptying a table..
>
>John,
>zap, delete and pack all work No question. The reason that the result you are looking at is not what one would expect, to my best bet is, is to be found in your coding or environment.
>what do you see in your debugger when you check for reccount()?
>Regards,
>Koen

Unless I'm mistaken here - he doesn't have exclusive use of the table ... so all of this is moot until that is resolved.