QuickBooks Pro 2016, DB error -185

Bobby
Bobby used Ask the Experts™
on
ErrorMessage:'SELECT returns more than one row' from file:'src\dmedlsqlcontacteditelement.cpp' at line 2686 from function:'DMEDLContactEditElement::LoadAdditional'

That error started about a month ago whenever we run balance sheet. We were able to figure out that it's an entry from 2008 in the amount of $20.74. Intuit techs say they need the file for 5 days to diagnose and maybe fix... we can't do that, way too long to be without QB.

I need to know:

Is it possible that this error will grow and corrupt the whole file? It doesn't bother us except when we run the balance sheet, no big deal.

If yes, then where do I find an onsite QB data repair tech?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
That error ought to be preventing QuickBooks from doing any of its internal, automatic backups so I would say you need to have it addressed!
With everyone out of QuickBooks, copy the entire data folder to someplace else for safekeeping.
Then, try the built in File Doctor:
http://support.quickbooks.intuit.com/support/articles/HOW21534

Author

Commented:
I do have a question on this... the docs say:

For data damage issues only, only run the QuickBooks File Doctor if you cannot open the file. If you can open the file and work inside it, do not run QuickBooks File Dr.

Since I CAN open it and work in it, does that mean I shouldn't run the file doctor?
I would hope that the file doctor would catch and fix the problem; but, as I said, make a backup copy first.

Author

Commented:
So you're saying that it is safe to use the file doctor, regardless of what I posted says? I read that as do not use the file doctor unless you cannot even open QuickBooks and that company file. No?
If you make a backup copy first, you can always copy it back if it does hurt things!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial