For years we have very successfully utilized a Back Office program that I have written in MS Access and VBA. It functions to 'bridge' our POS invoices over into Sage 300.
It uses the ACCPAC COM library for login and import of invoices.
This weekend I successfully completed the upgrade of Sage 300 from 2020.6 to v2024.1.
I am aware of the jump in password complexity and issues surrounding it (among other typical upgrade challenges).
I can successfully login to Sage 300 using "ADMIN" and the new password.
However, my custom Back Office program cannot login successfully and displays the following error message:
*******************************************************************************
Invalid Signon Information.
Make sure you supply the correct User Id and Password.-536870908
*******************************************************************************
The pertinent portion of the VBA code looks like this:
Dim mSession As AccpacCOMAPI.AccpacSession
Dim strSageUserId_Local, strSageUserPword_Local, strSageDatabase_Local As String
Set mSession = CreateObject("ACCPAC.Session")
mSession.Init "", "XY", "XY1000", "62A"
strSageUserId_Local = "ADMIN"
strSageUserPword_Local = "Password1!"
strSageDatabase_Local = "CFSAGE"
mSession.Open strSageUserId_Local, strSageUserPword_Local, strSageDatabase_Local, Date, 0, ""
**Error is thrown by the mSession.Open line above**
Thanks in advance for any assistance!!
