Click here to Skip to main content
15,888,301 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
We are running QuickBooks Enterprise 7 (I know it is old and not supported). I have MS Access applications that are using the SDK (via VBA) to send transactions to QB. Nothing to my knowledge has changed, but all of a sudden we are getting an error that the certificate for the application is invalid. We never had certificates before. It also did not pop up the window that lets me say I want it to run regardless of the certificate.

Anyone have any ideas what causes this? I have tried deleteing the application from QB and created a new one just to see what would happen but it still gives me the error.

My code looks like this:

QB = CreateObject("QBFC7.QBSessionManager")    
strDatabase = DLookup("Default_Company", "Configuration_table")
'get the qb file information
QB.OpenConnection "", "Upload Payroll"
QB.BeginSession strDatabase, omMultiUser
dblCredit = 0
Set JournalAddSet = QB.CreateMsgSetRequest("US", 5, 0)


really need help with this! Our company is dead in the water until I can get this going!

What I have tried:

I have tried uninstalling and reinstalling Quickbooks on both a client and the server, but that hasn't helped. I also tried removing the old applications in the Quickbooks list but I get the error when it goes to add it again.
Posted
Updated 1-Aug-17 5:32am

 
Share this answer
 
As I mentioned in the post, I am running QB version 7.0 - too old for their support.

Anyway, I did determine that is was the result of an Office 2016 update. I forced it to do another update and it fixed it. I have no idea what either update contained (that is my next task). At least we are back working again.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900