The program can’t start because VCRUNTIME140.dll is missing from your computer

If you are trying to install Microsoft Access Database Engine 2016 Redistributable, under certain circumstances you might get the below error message: The program can’t start because VCRUNTIME140.dll is missing from your computer. Try reinstalling the program to fix this problem. As it can be figured out from the error message, VCRUNTIME140.dll refers to the … Read more…

Internal Query Processor Error: The query processor could not produce a query plan

OK folks, it did happen a few days ago to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. I was trying to execute the following query: SELECT * FROM dbo.tbl1WHERE tbl2ID=(SELECT id FROM dbo.tbl2 WHERE Code=’Code1′)AND tbl3ID=(SELECT id FROM dbo.tbl3 WHERE Code=’Code2′) … Read more…