Although Paradox tables are flat files, they have some characteristics 
of databases, such as deleting records but leaving empty space where the 
records used to be, so the file size remains the same. Like SQL 
databases, you need to recover the empty space by vacuuming or 
restructuring the table. You can do this in 2 ways:

. Use the built in Paradox "Restructure". Open the table and go to 
Format/Restructure Table. Click on "Pack Table" to check the box, and 
"Save". You may consider backing up the table before you do this.

. Create an empty table with the same structure as your table. Copy all 
records to the new empty table. Overwrite the old table with the new table.

bob shin wrote:
> Hi
>
> I am using following query delete function to delete and to reduce file size
> but the file size in window is the same.
>
> ex  before query delete
> number of rec = 669035
> file size 487186 kb
> index size 1654 kb
>
>
> after deleting 99% of the records the file size is
>
> number of rec = 150
> file size 487186 kb
> index size 1654
>
> Records were delete but the system file size does not change.
>
> I have refreshed and reopen the folder to verify but still the same.  Also
> when I run a query the table it take as long, when the records size was 669035.
>
> Any idea?
>
>
> qbe = query
>
> :workretail:ginv#  | date |
> 		delete		|<~date1|
>
>   EndQuery
> qbe.createauxtables(true)
> qbe.executeqbe()
>
>
>
> bob shin