Solved

Connection problems to Quickbooks via SDK in VBA

Posted on 2009-04-06
5
1,259 Views
Last Modified: 2013-11-27
I am trying to connect to Quickbooks from an Access database using the Quickbooks SDK. I have my code sample below. The problem is that even though I have the open connection set up to be multiuser mode, somehow that property gets lost. Also, sometimes the computer that runs the commands becomes the host computer instead of the server remaining the host.

This problem does not happen every day. It does not seem to matter if the person using the SDK code is the only one in the system when the status changes. Sometimes it seems like something happens during the night (like during a backup or something).  We have gone a couple weeks where everyone logs in just fine in multiuser mode, the one day the problem comes back for a few days, then goes away again.

We recover from this by having everyone log out of quickbooks, then have the server manager search for the quickbooks database. Once we "find" the database again, it seems to reset the settings.
Is there something wrong in my code or in the server settings that would be causing this?

        SessionManager.OpenConnection2 "", appName, ctLocalQBD

        DTCompanyFile = DLookup("Default_Company", "Configuration_Table")

        SessionManager.BeginSession DTCompanyFile, omMultiUser

Open in new window

0
Comment
Question by:jadixon
  • 3
  • 2
5 Comments
 

Author Comment

by:jadixon
ID: 24077571

        SessionManager.OpenConnection2 "", appName, ctLocalQBD

        DTCompanyFile = DLookup("Default_Company", "Configuration_Table")

        SessionManager.BeginSession DTCompanyFile, omMultiUser

Open in new window

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24144581
Have you tried just contacting Quickbooks?
0
 

Accepted Solution

by:
jadixon earned 0 total points
ID: 24281225
After doing a bit of research it seemed to be a networking-type issue. So I went into the users etc\hosts file and added an entry for the server where the quickbooks resides. Since I have done that there does not seem to be an issue anymore. It has been several weeks since we had the lockout error. I am keeping my fingers crossed that this is really the cure!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24283201
OK

Keep me posted.

;-)

Jeff
0
 

Author Comment

by:jadixon
ID: 24380109
The ETC Hosts fix so far has worked. I will now close this out (until the problem happens again).
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Track name AutoCorrect info 14 46
how to link subforms ms/access VBA 6 27
subform is not filtered by link field 8 17
Access coding 2 0
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now