Aug 03 2022 09:58 AM
We use the ChempaxVB business system that uses Microsoft Access as the database. As of Monday this week, four users see a "Runtime Error" with no ID code and cannot open their "Reports Window". This is the ChempaxVB interface with the reports.mdb that contains all queries, forms and reports. So, they can use the software but cannot print. When they run ChempaxVB a temporary copy of chempax.mdb is created in their server Users\username\AppData\Local\Temp folder.
We are in a terminal server/RDP environment running Windows Server 2016.
I fixed this issue for one user by removing them from AD, deleting their profile and recreating them as if a new user. But the same process failed for two others.
This morning I've also tried creating a new test employee from scratch and get the same error. I've also reviewed the user's Access Options for macro and ActiveX security giving them the most trusted settings, including adding the ChempaxVB folder and even their server User folder to Trusted Locations.
We have seen some reports of a similar known issue in which VBA code cannot output to html or txt files; and that Microsoft is releasing an update, supposedly yesterday, August 2.
But I would expect, if it is known issue, that Datacor, the ChempaxVB supplier, would have other customers reporting the same issue. I am aware that Microsoft is making security changes related to macro security and wonder if this is related.
This may not be related but I forced the error, noted the time and then checked the Event Logs:
'The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{8D8F4F83-3594-4F07-8369-FC3C3CAE4919}
and APPID
{F72671A9-012C-4725-9D2F-2A4D32D65169}
to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC) running in the application container
Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool."
Aug 03 2022 01:32 PM
Aug 04 2022 06:15 AM
Aug 04 2022 06:16 AM
Solution