QB2007 is extremely slow over the network.

Posted on 2009-04-19
Last Modified: 2012-05-06

We have a workstation which is now a dedicated server running Windows Vista Home Premium. No other computers (all of which are XP) are sharing files. The speed between all of the PCs is great, EXCEPT for Quickbooks 2007.

We have setup the QB Database Server Manager as noted in the Intuit setup instructions. The Vista server has 2GB of Ram and an AMD 2.6Ghz Dual Core. The network is 100MBps and the adapter has been configured for 100 FULL.

All of the searches I have performed has yielded little info on our issue. I have applied all of the system and application updates.

Is there anything I can do to speed up this incredibly slow connection? The average DB size is roughly 100MB...which isn't that big.

Question by:trahan
    LVL 89

    Accepted Solution

    Your data file is not particularly big (as you note). Did you look at the transaction log on the server? If it gets large (as large as the database) it can slow things down.

    Also, I would not use Windows Home anything as a business server. It was not designed for this. That may be your issue. ... Thinkpads_User
    LVL 19

    Assisted Solution

    Does the Vista machine have antivirus installed?  If so have you tried adding this file to the exceptions list?  

    Have you monitored resource usage on the Vista machine when trying to access the db?

    Author Closing Comment

    Thank you. Both of your suggestions have improved the speed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    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…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now