Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Quickbooks Issue

Posted on 2016-08-22
5
88 Views
Last Modified: 2016-08-23
Hello all,
Here is the setup and the issue:
I have a client that has a WIndows 7 Pro computer with 4 gig RAM and an SSD hard drive.
When Quickbooks 2014 was double clicked on it would take only 1 minute for it to completely open the company file.
For some reason suddenly Quickbooks was taking 20 minutes to open (the company file is only 24 meg large).
I found that there was an issue with the svchost.exe (netsvcs) that was pegging over 1.5 gig of memory and I fixed that over this past weekend.  Know this process only takes up 25 meg of memory.
I uninstalled and then reinstalled Quickbooks 2014.
Now it takes six minutes to open up the company file.
Not sure what to do next.
With an SSD it should not be this slow and no other programs (such as Lacerte) take this long to open.  They are all fast.
Any help would be greatly appreciated.
Thanks,
Kelly W.
0
Comment
Question by:K_Wilke
  • 3
  • 2
5 Comments
 
LVL 93

Accepted Solution

by:
John Hurst earned 500 total points
ID: 41765988
it would appear the Company data file may be damaged.

Open QuickBooks, and open the Company file.  I assume from the description the file is local on the same SSD as QuickBooks is installed

Now, File, Utilities and Rebuild. It will make a backup first and back up the a USB key.

Let the rebuild proceed, restart QB and test.
1
 
LVL 6

Author Comment

by:K_Wilke
ID: 41766015
Will give that a try tomorrow morning.
0
 
LVL 6

Author Comment

by:K_Wilke
ID: 41767458
It is working and the solution is strange.
I ran the rebuild on the company file three times and it was fine.
Still took 6 minutes to start Quickbooks then open the company file.
I noticed that the computer is getting DHCP from the router and that the DNS was the IP address of the internal LAN of the router.  Changed the DNS to the IP addresses of the ISP the client was connecting to and now Quickbooks starts up and opens a company file in 25 seconds.
Thanks for your help.
0
 
LVL 6

Author Closing Comment

by:K_Wilke
ID: 41767459
Thank you very much
0
 
LVL 93

Expert Comment

by:John Hurst
ID: 41767462
You are very welcome and I was pleased to assist. I have a bunch of Company Files that are under 100 MB and they open in seconds from a hard drive.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multi-user networked Quickbooks issue with strange fix 6 867
QuickBooks Enterprise Response Time 2 144
RDS environment for 5 users and 10 97
Mapping QuickBooks data in excel 3 40
By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question