QuickBooks Premier Professional 2013-Connectivity Issue on a Network

Computer #1 has the database file and has shared the folder.

Computer #2 has a drive mapped the the database file on Computer #1.

If Computer #1 has a user logged in, while in Multi User Mode, Computer #2 receives a communication error H202.

Computer #2 can access and open the database file in Single User Mode when the User on Computer #2 is not logged into the database.

Computer #2 logs into the database and tries changing to Multi User mode and receives a "Cannot access the database" error, while Computer #1 has no user logged in.

I have run the "quickbooks connectivity tool", and it did not help.

Any ideas?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Computer number 1 should be set for Host Multi User access, not Multi User Mode (they are different).

Close QB on Computer number 2, set Computer number 1 for Host Multi User Access and keep QB running.

Now open QB on Computer number 2 and with the big center Open button, navigate to the database. Computer number 2 will want to use Multi User Mode to access the file.

Make sure you are using Mapped Drives (NET USE) and not browsing for the folder.
mapalaska2003Author Commented:
I verified that Host Multi User access was enabled on Computer #1, and checked the box "Multi User Mode". But I am still getting the error "Cannot communicate with the company file"
JohnBusiness Consultant (Owner)Commented:
Check firewalls between computers and that you are using mapped drives.

Make sure from Computer 2 you can use a file (Word / Excel) reliably on Computer 1.
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

mapalaska2003Author Commented:
Firewalls are OK. I am able to open office files on Computer#1, from computer#2
JohnBusiness Consultant (Owner)Commented:
Should work. Try the following.

Disconnect computer 2.

On computer 1, close QB, delete the ND and DSN files from the company data file folder.  Open control panel, programs and features and do a QB Repair. When done restart.

Now open QB and be certain you are in Host Multi User Access mode.

Restart computer 2, delete the folder map, and then remake the folder map. Open QB and navigate to Computer 1 (do not use recent).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mapalaska2003Author Commented:
Thanks John, you've made my day successful again. That did the trick.

Now off to address some server certificate issues.

Have a great weekend.
JohnBusiness Consultant (Owner)Commented:
Good news! Thanks, and I was happy to help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.