increase the default block size in the BDE.. make a copy of the table.. 
empty the original.. using the repair tool, change the block size.. now add 
the records from the copy, to the original

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Tony "  wrote in message news:5aae4caf$1@pnews.thedbcommunity.com...



I keep running out of room when I do queries it will work on smaller size
queries but the big ones run out of space 

------------ And now a word from our sponsor ------------------
Want to have instant messaging, and chat rooms, and discussion
groups for your local users or business, you need dbabble!
--  See http://netwinsite.com/sponsor/sponsor_dbabble.htm  ----