cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Established Member
Solved

QB Desktop - Saving Company File to OneDrive

We have experienced difficulty with trying to share QB Desktop client company files utilizing OneDrive.  It seems as though the company file does not refresh with proper updates and/or the refresh takes added time so that the file, as saved on OneDrive, may very well not reflect the most recent updates.  It seems as though this is a known issue when I google this issue as relating to the nature of the QB file.  Has anyone else experienced this or is anyone else managing the sharing of QB Desktop company files by utilizing OneDrive without any issues?  We are otherwise considering a cloud-hosted or remote in solution, but would like to be able to save money by utilizing OneDrive to manage the sharing needs of this file.  Thanks for any insight/advice!

Best answer 09-30-2017 12:29 PM

Accepted Solutions
Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

QB uses a Relational Database for the data file, and it is not Stand-alone; you overlooked that there are associated Utility files that get Live Updated while you work. That is why Multi-User (concurrent) has to be Managed = Database Manager Hosting app. Even if you are scrupulous about having only one computer at a time using that file stored in a Static (fixed) storage location, you still see those Utility files being updated, to keep track. That includes .tlg, .adr, .nd, .dsn, etc.

 

Unlike Word and Excel, nothing about the datafile is loaded into Local Memory and then put away when you are done. You know this, because in Word and Excel, you need to have Saved, or Saved at the end, before the file is Closed. But, as you work in QB, every single transaction and entry requires you to Save and Close or Save and New.

 

You cannot use DropBox, One drive, Google Drive, etc.

 

You can research QBox; this seems to be the only Managed Shared Storage for using QB data, as a managed relational database, that avoids creating conflicting data files.

22 REPLIES
ProAdvisor

Re: QB Desktop - Saving Company File to OneDrive

You can't put your QuickBooks file on One Drive or any other cloud based storage. It doesn't work.

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

QB uses a Relational Database for the data file, and it is not Stand-alone; you overlooked that there are associated Utility files that get Live Updated while you work. That is why Multi-User (concurrent) has to be Managed = Database Manager Hosting app. Even if you are scrupulous about having only one computer at a time using that file stored in a Static (fixed) storage location, you still see those Utility files being updated, to keep track. That includes .tlg, .adr, .nd, .dsn, etc.

 

Unlike Word and Excel, nothing about the datafile is loaded into Local Memory and then put away when you are done. You know this, because in Word and Excel, you need to have Saved, or Saved at the end, before the file is Closed. But, as you work in QB, every single transaction and entry requires you to Save and Close or Save and New.

 

You cannot use DropBox, One drive, Google Drive, etc.

 

You can research QBox; this seems to be the only Managed Shared Storage for using QB data, as a managed relational database, that avoids creating conflicting data files.

ProAdvisor

Re: QB Desktop - Saving Company File to OneDrive

Confirmation!

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

With a small ($300-$500) investment in an always on server of your own, and an IT pro to hep you set up your remote connections, you can self-host.

 

Intuit/QuickBooks offers a hosting service - no clue what it costs.

From the litte I  have read aboout Qbox it still is not true simutaneous multi-user

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Thank you for your thorough reply.  I do have a follow up question please...

 

When you backup and restore a QB Desktop company file, you are able to select the file path as to where to save that file.  I am presuming that the related peripheral files that you mentioned (extension types - .tlg, .adr, .nd, .dns, etc.) are saved in that same location as the company file.  So why would OneDrive be any different than saving that file to any other file path location?  In other words, why couldn't a user still use the QB Desktop file that was saved to the OneDrive location (just like any other file path location)?  Forgive me if I am missing something technical, but I very much appreciate any further response you can offer on this topic.

As you noted, we are otherwise considering a solution like QBox for sharing the company file with clients, but are wondering if that is even necessary for my business partner and I to share the file within the same office from separate PC's.  Thank you again!

ProAdvisor

Re: QB Desktop - Saving Company File to OneDrive

QuickBooks isn't designed for sharing the file in the cloud like One Drive or any other cloud storage. It is designed to be stored locally on a server or a desktop. This is really the bottom line of it. 

 

You can go to a hosted environment where the data & program are stored & you log in to that computer via the internet. Of course there will be a fee & you still have to buy QuickBooks & the licenses as they use your program.

 

Other choice is to set up a network where you share the file in house.

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

"When you backup and restore a QB Desktop company file, you are able to select the file path as to where to save that file.  I am presuming that the related peripheral files that you mentioned (extension types - .tlg, .adr, .nd, .dns, etc.) are saved in that same location as the company file."

 

You can Look at your own computer system. You will see subfolders and files, and the "company filename" from the Windows file is part of the Naming of the associated utility files and subfolders. When you Restore a Backup, you will also see a folder that is created for "Restored_XXXcompanyNameHere_Files" and in this subfolder you Also see a file named "HowToRestoreExternalFiles.txt" that basically is a ReadMe file.

 

"So why would OneDrive be any different than saving that file to any other file path location?"

 

You are relying on Synchronization, which is not the same as "database pointer" tracking.

 

"In other words, why couldn't a user still use the QB Desktop file that was saved to the OneDrive location (just like any other file path location)?"

 

Well, one of the biggest issues is the .nd and .dsn = Data Source Name and Network Data tracking, which keep track of "who" is in the file, by computer. That is why Multi-user = concurrent use, is managed by the Database manager hosting app installed on a computer.

 

It's not Just Like Word and Excel. It is required to be Managed, as I explained, because it is a relational database.

 

"Forgive me if I am missing something technical, but I very much appreciate any further response you can offer on this topic."

 

It is Very technical. I copied this text and kept it for reference, from another forum topic, for why you cannot use a NAS (network atteched storage device, or Sharing an external drive in the office):

 

"We have to be very precise with our terminology. There is a difference in the implications of iSCSI vs just mapping a drive. It's not enough to say Quickbooks supports or doesn't support NAS devices. It doesn’t support Unmanaged devices. People who don't understand the implications can get themselves in trouble, corrupting their company files.

This also is why Static Storage such as DropBox and One Drive cannot be used.

There is a big difference between a standard NAS and Enterprise Storage.  Quickbooks needs to run on a Windows host that has "exclusive block-level" access to the storage.  There is a big difference between a device that supports Fibre-Channel and iSCSI, vs one that supports SMB, CIFS, or NFS.  

Unfortunately many "wonder machines" depend on the user to know the implications and drawbacks of the different devices.    It's one thing to have a file server to share movies and general documents.  It's quite another to host a database.  Quickbooks is a database.  Or, more specifically it is an application built over a Sybase database.    SQL-Server and Oracle have the same issues running on an external device."

 

 

"As you noted, we are otherwise considering a solution like QBox for sharing the company file with clients, but are wondering if that is even necessary for my business partner and I to share the file within the same office from separate PC's.  Thank you again!"

 

I am glad to offer QBox, but that would be used for sharing Not from the same office. We though you needed access from two computers Not Located near each other. It is a Coud location.

 

In the Same Office and wanting to share a data file = Multi-user.

 

Both computers install the QB program = you pay for two licenses or "seats." One computer is Hosting = installs the Database Manager hosting service, an app that runs at startup, and you don't need QB open on that File Hosting computer. Both computers Wired via an ethernet network, even if peer-to-peer through a router. You set up usernames in each file. Your Windows user needs to be Local Admin on the hosting computer, even if working from the "other" computer.

 

 

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Help! I just read this article and found out that I can NOT use Dropbox to share company files with my accountant! And I have been doing it for a couple years now....  Smiley Frustrated  It seems to have been working....  But am I in danger of losing or haveing my files corrupted at any time?  Smiley Sad

ProAdvisor

Re: QB Desktop - Saving Company File to OneDrive

It’s quite possible. QuickBooks is not designed to be used that way. It needs to be used on a local computer.

ProAdvisor

Re: QB Desktop - Saving Company File to OneDrive

Like stated below, it won’t work. You can end up with a damaged (conflicted) file.  

 

You may want to consider moving to QB online.   It is cloud based without all of the issues of hosting with desktop.  

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

It depends on what type of file you are sharing with your accountant via dropbox. You can safely store an Accountant's copy of desktop on Dropbox for them to download in lieu of emailing through QB. You could distribute a Portable Company File or a saved backup. 

Established Member

Re: QB Desktop - Saving Company File to OneDrive

As far as sharing the folder, I'm not sure how that will work for you.  I couldn't imagine that multi-user simultaneous access is going to work, as others described about the nature of the DB file. 

 

I did see replies in this thread about the ability to just use the company file on OneDrive, and I wanted to add my $0.02.  I'm on QBpro 2017, and you certainly can use it on OneDrive, it'll just clobber your network constantly writing to the database file.  Even my IP cc pos terminal up at the front desk chokes when I'm in the file.  I'm a small sole prop, single user, and only make my montly entries in QB once a month for about 30 min or so it's not a big deal.  If I need to be on the file for longer, like for year end JE's etc, I will just pause OneDrive for a couple hours, or whatever, and then when I'm all finished up and closed the file, re-enable OneDrive.

Senior Explorer *

Re: QB Desktop - Saving Company File to OneDrive

It has been my experience that QB Desktop does not always like to be 'e mailed'. Other ways do transfer well. 

 

You may consider QBO so more people can access your data.

 

Cherilyn Collins

Established Member

Re: QB Desktop - Saving Company File to OneDrive

How did you access you QBW file on onedrive? I have mine saved there, but when I open company file by browsing to the onedrive location, I get a "(-6176,0)" error...thanks!

Moderator

Re: QB Desktop - Saving Company File to OneDrive

Hello meyerjamesk,

 

I'll join in this thread to share some details about the -6176, 0 error.

 

This error is caused by firewall blocking the connection between the computers. Here are some troubleshooting steps that can help you fix this error:

 

First, try opening the file again. You may only see these errors the first time you attempt to open a company file and opening the file a second time results in success. Next, make sure QuickBooks is updated to the latest release.

 

You can also toggle the UAC setting, here's how:

 

Windows 10, 8.1, and 8

  1. Close QuickBooks.
  2. On your keyboard, press Windows logo and type User Account Control.
  3. Go to Settings > Change User Account Control Settings.
  4. Make note of the current level and then move the slider to the highest setting, Always notify.

For more recommended troubleshooting steps, check this article:

That should work for you. If you've got other questions, feel free to leave a comment below. I’m always happy to help.

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Hello, thank you for taking the time to help.

 

On your first point, I've tried multiple times to open this file, and have had no luck. I'm also on the latest release.

 

On your second point, I changed my computer to "always allow", but this went to my C:drive...the QBW file is on my OneDrive which has been mapped to my windows explorer as a ZSmiley Very Happyrive.

 

I also checked the links that you had provided. I tried to change my ND and TLG files to ND.OLD and TLG.OLD. This did not work. The other option was to copy my file to my desktop to see if I can open it there. I can open it when it is saved locally.

 

It seems that it is not able to be opened because it is stored on my OneDrive (which has been mapped to my Z:drive in windows explorer). Any other thoughts? I would love to not have to carry around my external hard drive (which is where I am able to access my locally saved QBW file).

 

Thank you!

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Hello - I think I may have just replied, but it seems to have not saved to the thread.

 

On your first point, I tried to open multiple times and checked my version (latest version available), but I cannot access.

 

On your second point, I checked my access and it is on "always allow", but this is for my CSmiley Very Happyrive. My file is on my ZSmiley Very Happyrive (which is my OneDrive mapped to windows explorer)

 

I also checked those links. Some tell me to copy it to my desktop and try to open. I am able to open the file from my locally saved version on my external hard drive. I also tried to switch the ND and TLG files to ND.OLD and TLG.OLD, but this did not work.

 

Any other thoughts? I don't want to have to carry around my external hard drive to access my quickbooks! Thanks!!!

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

@meyerjamesk

 

This is your problem: "I also tried to switch the ND and TLG files to ND.OLD and TLG.OLD, but this did not work."

 

You cannot use OneDrive because these types of files are Live Updated as you work. But OneDrive and DropBox and Google drive are "static storage" which means they cannot handle that the QB data file is a Relational database. Word and Excel will load the entire data file into local memory while you work. QB does not Manage the data file like this. Think of the QB connection to the data file as if that is a phone call you cannot put on hold or even set down the phone.

 

You can investigate QBox; that seems to be the only cloud storage for the relational data file that works for QB.

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Thank you for the info. I’ve seen conflicting opinions on this. You say that OneDrive cannot be used because it is static storage, but others say that it can be used. Just confirming that there is nothing I can do to be able to use OneDrive to access and backup my QB file? I’m thinking maybe if I can turn off the auto save feature or something and just do batch saving and backups? Thanks!

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

OneDrive, Google Drive, Dropbox, can be used to Store the Backups = .qbb and .qbm. Think of this as for disaster recovery purposes = offsite safe storage.

 

OneDrive, Google Drive, Dropbox, cannot be used to Keep the .qbw file, the working file and folder and subfolders and associated utilities files, attachments, filed forms, anything linked to the Company file, or the Company File itself and not for Any place that would be your Company File's folder or library or file path. The Folder with the files that are live updated cannot be a Static Share.

 

There is no debate for QB PC Desktop. The Working file and folders need to be Managed. OneDrive, Google Drive, DropBox, are not able to manage a relational database that is Live Updated as you work.

 

Yes, this can be pointed to a USB, to your DropBox, Google Drive, OneDrive: "I’m thinking maybe if I can turn off the auto save feature or something and just do batch saving and backups?"

 

Let the QB program make backups and set it to Rotate them = keep only the most recent 3 or 5. This is a Perfect way to use Static Storage locations, including your own USB memory stick.

 

Established Member

Re: QB Desktop - Saving Company File to OneDrive

Thank you. I am already backing up to an ext hard drive and OneDrive, but was hoping there would be a way to open my QBW file from

OneDrive as well so that I do not have to carry around my ext hard drive every time I want to work (I don’t save anything to my actual computer.) 

Established Community Backer ***

Re: QB Desktop - Saving Company File to OneDrive

This is Exactly what leads to a corrupt QB data file: "but was hoping there would be a way to open my QBW file from OneDrive as well."