I am a small town bookkeeper who does business support to local small businesses. We all purchase copies of QuickBooks. We have successfully shared the data file via drop box, by accessing the local data file stored on the computer. We learned early to make sure only one user at a time can access the database, this avoids duplicate and conflicting versions.
However, with the most recent updates of qb pro 2019 I have one company where he can no longer open the data file. We have been operating like this for 4 years, so i am confused as to what setting has changed. And why for only one of my companies.
We would consider switching to QBO, but that won't happen until QBO payroll functionality improves. ( I have 8 companies with QBO)
Hi there, Hedg.
Using QuickBooks Desktop isn't recommended to be hosted on file sharing services such as DropBox. This means that accessing your file in DropBox may or may not work, especially if there are constant updates.
You might want to consider using Windows Remote Desktop or subscribe to one of the accredited hosting providers. Both options allow QuickBooks users to access company file remotely, as long as they're connected to the internet. Please see these articles for more details:
Visit us again in the Community if you have other questions.
hi @Hedg ,
We don't recommend to use Dropbox anymore to our clients in Indonesia and Asia sharing their QBW files. Many of them have found their QBW files were easily corrupted in the past. Now we only recommend our clients to use hosting service / private cloud solution provided by a UK company. Their solution is relative easy to deploy and maintain without certain technical background. We have noticed as well that their monthly/annual subscription service is still lower than most similar solution in the market.
I am in Canada...
I understand what you are saying, however we have been successfully sharing the data file on drop box for years.
Hello there, @Hedg.
I'd like to redirect you to the right support so you can get the help you need.
I appreciate the details you've provided which help me better understand the issue. Since you're only experiencing this with one of your company files, I encourage you to contact DropBox customer support. They'll be able to investigate this issue and share some troubleshooting steps to help you share the data file to DropBox successfully.
Please know that you're always welcome to post if you have other questions about your QuickBooks service. Have a good one.
however the error we get is a data base error from Quickbooks.
so not sure how Dropbox will be able to help, i am more than willing to try, but could you provide me more information as to what i should be asking Dropbox about a Quickbooks error message.
only started with the latest updates to 2019 (as in the last few weeks)
the data base is 74,000 kb so not really very large in the scheme of a 4 year old company.
Hello there, @Hedg,
Let's perform some steps so your client will be able to open his/her company file via Dropbox.
Since you have a database error from QuickBooks, you can download and run QB Refresher tool on the computer you're having trouble with. This will close background processes that might be causing the error and do a mini refresh of your program files. Here's how:
If the first step doesn't work, you can ping server to ensure you're connected to the network. You can do it on a client workstation to ensure it can access the server. Here's how:
If your're still getting the same error after performing the second step, you can search for all company files on your server computer. Please make sure to include the Asterisk (*) before the extension type to ensure the search works correctly. Here are the list of the company files:
Once the file is found, you can make a note of the file's location. Then, proceed to the solution 3 under the If you are accessing your QuickBooks file over the network section through this article: Company File is Missing or Cannot Be Found.
If the file isn't found, I'd suggest consulting an IT professional to help locate the file.
Stay in touch with me after performing the steps above, @Hedg.
If you have other concerns, please let me know. I'll gladly help.
as instructed I tried:
QBRefreshdata base - still wont open the file.
pinged the server, no packets lost
I have the file, I can see the file date of access change.
it has something to do with quickbooks and dropbox no longer working together.
I can see if we were running several users, but we operate as single users, with only one person accessing the data base at a time,
After years of running successfully sharing the data in drop box, it is frustrating that we need to now run another computer, as a VPN, with different remote log ins to attempt to do the same thing.
It appears QB is trying to push people to QBO (I have 8 QBO client) but there are some companies where QBO is not quite the right fit.
I am unimpressed.
Welcome back to the QuickBooks Community, @Hedg.
I appreciate you sharing to us the result of the troubleshooting steps given by my colleague. Let’s try some new ones to help open the company file.
We can start at suppressing the desktop program when opening it. This allows you to start QuickBooks without opening a company file or no software window open.
If you can open the file, check if there’s only one computer is hosting it. Here’s how to turn off hosting in all computers aside from the server.
For detailed instructions, check out the steps below.
If the issue persists, you can continue performing the troubleshooting steps in this article and proceed to Solution 2: Prevent QuickBooks Desktop Windows from Automatically Opening.
This should help you get back on track.
Let me know if this works when you get the chance to try them, or if you need further assistance with any of these steps. I am here whenever you need more help.
OK how frustrating is this...
I have followed all your instructions: to date no one has told me what has changed regarding QB19 -
You can contact our phone support, Hedg.
I appreciate you for trying the solutions my colleagues have recommended. At this point, it would be best to get in touch with our customer care.
Here's how to do it:
You can always get back to me if you have other concerns with your program.