What site were these hands from? Party? There were issues with this kind of bad data caused by a Party update that were fixed a very long time ago. The solution is to export all these old hands to text files using the Utilities > Export Hand Histories To File option, then purge all these bad sessions and reimport the files again.
I fixed the problem with your advice. However, I now get an error that says SQLSTATE=S1000 The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
That error means the database file is likely corrupted.
Open the File > Maintain Database Names window. Double-click on the name of the database that you get errors with. What is the name of the file and the size that displays in the window that opens?
Sorry to throw one more thing at you. I'm running Windows on a Macbook. During the partition, I didn't allocate enough hard drive space! I'm completely out of space. I try to compact outside of PT (using ODBC) and I've tried to 'one step compact' but neither work as I have no space. Do I have any other options at this point? I've already deleted everything on my hard drive that I felt safe to do so. The size of my C: drive is 5.4 gigs so I thought that would be plenty of space...
I can't even do the repair from ODBC right now because I have no more hard drive space. I'm running WIndows on a MacBook and when I partitioned the hard drive, I didn't allocate enough space. I've deleted everything that I can but the PT files are taking up a lot of space. My C: drive is almost 5.5 gigs. Do all the hand files take up that much space? I only have about 100,000 hands in my database.