SOAP for VBA Upgrade

I recently had to upgrade an MS Access application from Office 2003 (MDB) to Office 365 (ACCDB). This application uses a SOAP connection to pull in XML from a Process Server in New York.

The original application was using MSSOAP30.dll in C:\Program Files(x86)\Common Files\MSSoap\Binaries\MSSOAP30.dll.

In order to upgrade the application, you will need to remove this MISSING dll and replace it with the new Office version.

  

Replace the Reference with the one shown below, found in C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSSOAP30.DLL.

OR this one for 32 bit Office.

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSSOAP30.DLL.

 

Outlook 2003 Calendar Reminder Fix

I had some issues with my Outlook 2003 Calendar at the office and had to create a new Calendar and remove the original one. I then discovered that the Reminders stopped working so this is what I did to correct that issue.

  1. Archive the Calendar using today's data as the 'older than' criteria, using File->Archive
  2. Shutown Outlook via File->Exit.
  3. Run the following Commad via Start->Run. outlook /CleanReminders.
  4. Shutown Outlook via File->Exit.
  5. Run the following Commad via Start->Run. outlook /ResetFolders.
  6. Done! The reminders sprung back to life.

Enjoy! I hope was helpful for someone out there!