A client of mine is using Quickbooks 2009 and has been having issues with accessing Quickbook files hosted on the Quickbooks database server. \u00a0All firewall ports are open, the database server is running and the Quickbooks Connection Diagnostic Tool says everything passes. \u00a0They access the files from a mapped drive to the server. \u00a0It’s never ran or performed as well as I think it should on a gigabit network with\u00a0fairly\u00a0new machines.<\/p>\n
After doing some research I tried accessing the Quickbooks files over a UNC path rather then a mapped drive. \u00a0The performance difference was night and day. \u00a0The files opened nearly instantly and it ran as if the QBW files were locally stored.<\/p>\n
From Intuit’s\u00a0website<\/a>…
\nNote:<\/strong> In prior versions of QuickBooks, Intuit recommended that a mapped network drive be used to access QuickBooks company files. With QuickBooks 2006, the UNC path, or direct path to the company file will work better than a mapped drive.<\/p><\/blockquote>\nReferences: Network Diagnostic Tool<\/a>, Should I use a mapped drive?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
A client of mine is using Quickbooks 2009 and has been having issues with accessing Quickbook files hosted on the Quickbooks database server. \u00a0All firewall ports are open, the database server is running and the Quickbooks Connection Diagnostic Tool says everything passes. \u00a0They access the files from a mapped drive to the server. \u00a0It’s never…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[3],"tags":[65,68,66,67,40],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-it","tag-intuit","tag-mapped-drive","tag-quickbooks","tag-unc","tag-windows"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1vc3H-1X","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":5,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":130,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions\/130"}],"wp:attachment":[{"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seanism.com\/blog\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}