« Running a Sales by Item Report in QuickBooks | Main | Discover the Business Plan Tool Inside QuickBooks »

March 01, 2011

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00e5536d63478833014e5f7d2b92970c

Listed below are links to weblogs that reference QuickBooks and Wireless Networks - They Don't Play Nicely With Each Other:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

It is too bad they are not compatible with WiFi. I do hope that will change someday.

If only the traditional versions of QuickBooks (Pro, Premier, Enterprise) can be used on a wireless network! That is sad that they are not designed to work here.

Will they release a version that will support wireless networks? Thanks

Will you create a newer version that would be compatible with a VPN connection? Thanks

Hi Greg:

Thanks for taking the time to stop by and post your insights on this issue. Some really, really good stuff that you have shared here.

An interesting note about SBS2011 - I'll have to get with my IT buddies to see what that is all about.

I see many businesses balk at the cost of using a hosting company and then try to arrange some other type of remote access that usually causes all sorts of grief (especially when trying with Pro and Premier!).

Lots of options indeed for a business that is spread out across multiple locations.

Scott Gregory

Hi Kathy:

Thanks very much for your post.

You and I benefit from having this level of deeper knowledge about QuickBooks.

Unfortunately, there are many non-techie users of it that believe "a network is a network" and expect it to work for them. I think this is especially true since there are no type of warning messages about trying to use QuickBooks on a wireless network.

I think Intuit could do a better job of pointing this out as part of the installation routine. Would you agree?

Keep cranking out those great QB reference books!

Scott Gregory

The problems with wireless aren't really connected to QuickBooks; it's a problem with all relational database structures. When QB switched to Sybase as the "underpin" database, the wireless connection became problematic the same way it does for all relational databases. SQL Server, MySQL, etc. all provide cautions or warnings about problems incurred with wireless connections. (Let's all hope that Intuit will use the relational database structure in the software some day - at the moment it's a flat database structure running on a relational database foundation; what a waste!)

As most of us in the business know, Quickbooks panics whenever it "loses sight" of its database for a millisecond. The program has become more robust over the years but it still needs a CONSTANT network connection to avoid errors and corruption.

In our experience we've found that business-grade WLANS (we install Sonicwall and Cisco gear) can run QB reliably. Consumer-grade linksys/netgear/d-link devices tend to be troublesome and just don't have the processing power to handle large amounts of encrypted data.

Let me make one major addition:
Cloud: QUICKBOOKS COMPANY FILES DO NOT BELONG IN THE CLOUD. We have tried several different providers, and even those using a local cache still have enough lag and file system mapping that the QB DB connection will break, even in single user mode. It's a company file corruption waiting to happen. Similar to a NAS configuration, we recommend hosting the company on a local workstation that backs it up to the cloud.

For those businesses who want/need to have multiple users in multiple locations accessing a company file at the same time, there are options:
1. Use one of the intuit-approved QB hosting providers
2. Use gotomypc, logmein, etc to remote into desktops on your local network
3. We've found that Windows terminal services configurations are stable and reliable when set up properly (although technically unsupported by Intuit). SBS2011 gives us the ability to very easily run server-based applications on a remote desktop, which is nice because the Quickbooks data connection is not reliant on your network.

Keep in mind that each of these setups has its own performance and security ramifications.

QuickBooks just pushes too much data back and forth through the network to do that reliably over the long haul without wire. Good call.

The comments to this entry are closed.

Follow Me!

Bookmark

Site Meter