Had the same issues. Way I fixed it was by using the above solutions, but because I needed it to open a specific database, I did the following:
Create a notepad document and put in the following:
@echo off
C:\Windows\System32\cmd.exe /c start "NAME OF PROGRAM HERE" /Affinity 3 "C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\FilePathTo\Database.mdb"
I then saved this as FIX.CMD
Then I changed the file path of the shortcut to be pointing to FIX.CMD.
Now when I click on the Icon, It quickly flashes the CMD box, but will run the database and when it opens MSaccess, it will have affinity of 3 (CPU 0 and 1 only)
This really caused me a headache, so I created an account on here to hopefully help somebody.
Thanks!
