Subject: Quicken 2007 for Mac — “Transaction File Is Full” Error When Recording Scheduled Transactions
I have been using Quicken 2007 for Mac for many years and would like to continue using it rather than migrate to a newer version.
My current data file is approximately 42.8 MB and contains transactions dating back to December 31, 2009. I previously divided my Quicken database at that date to reduce its size.
The Problem
Whenever I attempt to record a transaction from my Scheduled Transactions list, Quicken displays the error message:
“Transaction file is full.”
However, I can enter transactions directly into my checking account registers, save them, close Quicken and reopen the file with those transactions correctly recorded.
The problem appears confined to scheduled transactions.
Troubleshooting Already Completed
- Reindexing: Reindexed the database three times using Command + Option + B. No improvement.
- Backup: Successfully used File → Backup to Disk. The backup and original files are both approximately 42.8 MB.
- Save a Copy: Attempted File → Save a Copy, but received the error message “Unable to erase partly-copied files.”
- New Test File: Created an entirely new Quicken data file and successfully created and recorded a scheduled transaction. This indicates that the application itself is functioning correctly and the problem is specific to my existing database.
- Deleting Scheduled Transactions: Deleted an existing scheduled transaction and was then able to create a replacement without an error. However, attempting to record that replacement produced the same “Transaction file is full” message.
- Other Scheduled Transactions: The error occurs with all scheduled transactions, not just one particular entry.
Database Characteristics
My database contains approximately 25 scheduled transactions, two checking accounts, one credit card account and approximately 20 investment and asset accounts.
Only 7–8 investment accounts have regular activity. Many of the others are asset accounts containing only a few historical transactions, such as the original purchase of real estate.
Some current securities holdings were purchased before 2022, so preserving historical investment cost bases and tax lots is important.
Questions
- Is “Transaction file is full” a known internal capacity limitation of Quicken 2007 for Mac, particularly involving scheduled transactions?
- Is there a way to repair or rebuild the scheduled transaction records without reconstructing the entire database?
- Is there a database repair or compaction procedure beyond reindexing and Save a Copy?
- If dividing the database is necessary, what is the safest method for Quicken 2007 for Mac that preserves investment holdings, acquisition dates, cost bases and transfers between accounts?
I have preserved my original data file and backup and am conducting further testing only on a duplicate.
I would greatly appreciate advice from anyone familiar with the internal database structure and limitations of Quicken 2007 for Mac. My preference is to continue using this version if possible.