Can't Copy a DBF 1

[robulator]

I have a large DBF with a large associated DBT. I would like to do a COPY TO so I can shrink the DBT, but whenever I do it the resulting DBT becomes so big that it consumes my hard drive. Obviously abnormal. I've tried it in dBase III +, dBase 4 and with Clipper. Same thing. I can access the database just fine. Anyone know what is wrong.

Thanks,

Rob

 

[circes9]

A thought....
1. do a copy stru to make a new file...
2. write a clipper app to append 1 rec at a time to the new file
Good luck
Circes

 

[pappdenes]

Is there any reason for not using the DBTPACK utility?

 

[fibonacci]

create a new file with the same structure and copy your file to the new or use the program that Rick Spence sugest for pack the DBT files

 

[robulator]

I did as Circes suggested (thanks!) and I no longer had the problem of the DBT blowing up when copying it (some other problems we'd had also went away). However, now when I do a copy, the resulting DBT file is essentially empty. I seem to be able to live with the old DBT file for now, but for how long I don't know. Perhaps I should try DBTPACK next. Where do I get it?

Rob