I am using Access 2000 as an order tracking system in a manufacturing environment. I currently have 22,000 entries (lines in my master table). We add about 125 new orders per day. The initial database was 48 megs, now after 3 months it has growen to254 megs! We access the data from the master computer and one slave computer, using Windows 98 peer to peer, with a six port hub. The database is growing at 2 megs per day with only 125 new orders being added. Something is wrong. Since we added access from the slave machine the database is growing like crazy. What should I do to clean up the database? We query the database all day long to check orders. I think this is what is making the database grow so rapidly, not just adding the 125 new orders per day. Any help would be truly appreciated. I can not purge the old orders until they are atleast 6 months old (for tracking and invoice purposes). I am new to the program, so please be as detailed as possible so I may follow your instructions.Regards
Darren Irvine
