Company file size too big

Hi, Thompson.

Ten years worth of information can be a lot of records, and I appreciate your loyalty to QuickBooks. I'm here to help you fix the error 6190, 816 and work with QuickBooks smoothly.

Error codes 6190 and 816 happens when another user is logged in to the company file in a single user mode. To isolate the issue, please make sure to update your QuickBooks to the latest release to fix common issues with your file. From there, disable multi-user access. Here's how:

1. Access your QuickBooks company file as the Admin.
2. Go to the File menu, then select Utilities.
3. If Stop Hosting Multi-User Access is listed, choose to Stop Hosting Multi-User Access.

Once done, create a backup copy of your company file. Then, download and install QuickBooks Tools Hub, then run the Quick Fix my Program. This is a built-in tool that auto-detects and auto-fix data damage issues within QuickBooks.

1. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub.
2. Locate the file you downloaded (QuickBooksToolHub.exe).
3. Follow the on-screen steps to install and agree to the terms and conditions.
4. From the tool hub, click Company File Issues.
5. Choose Quick Fix my File.
6. Click OK when it completes and launch your QuickBooks.

For additional troubleshooting steps, you can check out these links:

• How to fix Error 6000,-83
• Fix company file and network issues with QuickBooks File Doctor

On the other hand, yes, you can get your past year/s data to start a new file. However, you need to prepare big storage that's capable of saving larger data. 

Another option is to reduce your file size but leaves all the detailed transactions. You can use this link as your guide: Use the Condense Data utility.

For additional resources, while working with QuickBooks in the future, you can review the topics from our help articles.

If you have any other questions, please let me know by adding a comment below. I'm more than happy to help. Keep safe!

"On the other hand, yes, you can get your past year/s data to start a new file. However, you need to prepare big storage that's capable of saving larger data. " How would I do this?

Thanks for getting back to us, @athompsoncmc. Let me be your guide today. I understand that you don't want to start a completely new company file. You don't have to do that. 

The good thing is you can copy and use everything such as your accounts, lists (customers, vendors, items, etc.), templates, and preferences from an existing company file to get started.

All you have to do is to create a copy of your existing company file. Then, condense the file to remove all the transactions. Get more insights through this help article: limitations when condensing your data. 

First off, back up your company file, then follow the steps below to create a copy of an existing company file: 

1. Open QuickBooks Desktop and the company file you want to copy.
2. Press F2 to open the Product Information window.
3. Look in the File Information section. This shows where your (backup) company file is saved on your computer.
4. Use the backup to restore your company file. This will create a new company file with the same accounts, lists, templates, and preferences.
5. Rename the file when you restore it to create a different copy of your original company file. Save the new file to a unique folder.

You can now start fresh by deleting the transactions QuickBooks also copied over. Here's how:

1. Open and review your new company file.
2. Go to the File menu and go to Utilities. 
3. Select Condense Data. If you receive a message about removing budget data, select Yes.
4. In the Condense Data window, select All Transactions and then Next.
5. Follow the on-screen instructions to remove the copied transactions.

After that, all transactions should be removed. Now, check your accounts by running a Transaction List by Date report to check if your accounts are empty. Otherwise, edit and delete them. 

I'll be here to answer and help if you have more questions. Have a great day!

@athompsoncmc 

Have you tried to run the Condense Data utility? If your condensed file is still larger than > 200 MB, you may have 2 options:

1. Purchase a 3rd party condense service.

2. Run the condense utilize to split the file.

Another option is to SuperCondense your data file.

https://www.google.com/search?q=Quickbooks+supercondense

You could look at using a 3rd party service provider who can do a condense of your file. Some of them offer a guaranteed service as well.