In some instances (seems to be when saving a new customer or supplier) the software crashes and leaves the database in an un-usable state. To fix the problem you have to run the quickbooks file doctor.
So, with the normal "it worked for me, YMMV, At your own risk..." this is how I fix it;
On the server (or the workstation hosting the files)
logon as an admin user (just to make sure)
run services.msc as administrator
stop
1/ qbcfMonitorService
2/ quickbooksDB23
copy quick books company file file to desktop from it's normal home;
run file doctor as administrator
pick the correct file
enter the QB Admin password
whilst it's analysing the file
select all files from the data file sub directory and cut them
(not the shortcut to backups or any of the folders)
goto your quickbooks backup folder
create a directory called "file recovery <todays date>"
Ener that directory and paste the files cut earlier
Go back to the analysis window, which will probably still be going...
When prompted tell it you are on the server
close the browser window that it opens for you
close the file doctor
cut the (now repaired) company file from the desktop and paste it back to it's correct location
check the two services stopped previously are started again (the file doctor normally does this)
browse to the company file VIA THE NETWORK (not locally)
double click the data file to open quickbooks.
logon as the qb admin user
switch to single user mode (file, switch to single user mode)
(you may need to get people to log out if anyone is on)
go to the banking menu then write cheques
click "pay to the order of" then press CTRL + L
close the name list and the cheque writing window
Click File, Utilities, Verify (this takes a few mins)
When it finishes open qbwin.log
Open in notepad and find all occurrences of "duplicate" names and id numbers
File, utilities, Rebuild
Pick the same folder you created erlier to backup the data files too
switch too multi user mode
email someone at the customers the duplicate names
ReplyDeleteHey what a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and will look for more postings from you Get for more information quickbooks phone number
Great job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Thank you because you have been willing to share information with us.Sage 50 Cloud Accounting Package Provider Dubai
ReplyDeleteI found decent information in your article.QuickBooks tool hub I am impressed with how nicely you described this subject, It is a gainful article for us. Thanks for share it.
ReplyDelete