>hey joe,
>
>i saw this link from an egroups, this may be the answer to my/our problem, but honestly i havent figured this out yet. maybe you wanna try it and if it works, let me know (and explain it to me hehe)
>
>
http://support.microsoft.com/support/kb/articles/Q119/1/16.asp>
>thanks!
>elinore
In their example, essentially, you copy all the records to a new temporary table, delete the old one, then rename the temporary table as the original name. For a ZAP you would create a new empty table overwriting the old table with records. This does not seem to handle indexes so you will have to reindex or recreate you indexes. :(
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams
