Database file size went from 16.78GB to 16.42GB. That's it. And yes, I created a whole new file.
What's incredibly frustrating is that it took... I kid you not... _5 hours_ to perform that action. And all I trimed off was a few MB.
Is this a freak occurence or is there something else afoot?
When you delete the other companies records, did you first delete the child records related to the parent record? For Example Company A has 100 invoices. You would delete the invoices first then delete the parent record. If you have seleted in the relationship table Delete record in this table when another record is deleted in other table, then the invoice should have been deleted.
1. Make a backup of your databases. Save a copy as 'copy of current file'
2. Make a clone copy without data. Save a copy as 'clone no records'
3. Check file size of your clone copy. This will tell you if it has to do with the databases themes (Still Large) or Data if it is smaller.
4. If smaller then I would just import the records I needed instead of all the records. You can import based on the current found set.
See this link about importing
5. You can do another save as compact to make this new database even smaller
I would bet that you have some records related to the other companies still in your new database.