QB_Doctor has the right idea. Quickbooks has since updated this with their latest release.
Ok... so I've a read a TON of different suggestions here... but I'm still not sure what to do in my company's case...
We have Enterprise 11.0 and our data file is 1.6G (dating back about 7 years) with roughly 9 users in at any given time...
We are getting a lot of "working" pop-ups... and sluggish movement between transactions... add in the occasional complete shut-down... and we're definitely in need of a solution.
We have considered the following:
-- Condense/Clean Data Utility -- but have seen that there is a lot of file integrity damage with it
-- Shrink the file -- but most outside companies that offer this service only reduce it by 20%... and is that really that much that it would help??
-- Create a new company file -- concerned about not transferring all the necessary information to function smoothly
I would love to hear from someone who actually had this problem... and exactly what THEY did to fix it... and if they've had any trouble since then...
This original post is three years old and a lot has changed in that period of time. Today I would recommend doing a data shrink and leaving the last two years in the file. I have several clients who have done this and are very happy. Also we have been told that the condense feature in QB has been resolved, however it has been said with caution and not tested. As many problems as I've seen arising from the built in utility, I hesistate to go that route. Often times customers have already used the buggy tool in QB and have created data integrity issues that can't be resolved through QB. The data shrink service we provide clears up the data integrity issues.
Also, QuickBooks enterprise is designed for growing files, but a lot can go wrong if not setup properly. There are many proadvisors that know QuickBooks some are certified, even fewer are advanced certified. There are also few that are authorized resellers of QuickBooks products. There was mention of finding a quickbooks proadvisor on staff to get discounted pricing. This is no longer true. The only people allowed to sell QuickBooks Enterprise are direct and an Intuit Solution Provider (ISP). The difference is that buying through an ISP supports our local businesses and more often than not if your ISP is also advanced certified QB Proadvisor, you will have a much better installation experience than struggling through it yourself.
QBES has lots of benefits that you may not realize, one is that you get US based support for a year. We always recommend renewing it annually because you stay on the latest edition. With Pro and Premier you have to go back and buy the box all over again. With Enterprise, it is more of a business software. Pro and Premier have list limits of 14,500 and Enterprise is well above that at least 100,000 plus. You can set security limits inside of Enterprise that you cannot do in Pro and Premier such as keeping people out of your payroll. It is designed for multi user access and to be put on a server. This is just a few of the features. It is far superior to QB Pro and Premier and is worth taking a look.