Microsoft Access Class Not Registered Run-time Error -2147221164 (80040154) Class Not Registered

This error occurs in a Microsoft Access database that seems to work fine on every other machine but one. The MS Access database actually loads and runs, so the code is compiled and functional. Then it dies on some very common code such as CurrentProject.Connection for ADO to open a table or query recordset:

Microsoft Access "Class Not Registered" Run-time Error -2147221164 (80040154)

Confusion

The “Class Not Registered” is very confusing. It implies code that won’t compile or broken library references but that’s not the true cause. Is the Access database corrupt? No.

We’ve received reports for this error for years and were never able to reproduce it. We finally did and figured out why it occurs and how to fix it. Read our new paper Microsoft Access “Class Not Registered” Run-time Error ‘-2147221164 (80040154) to learn more.

One thought on “Microsoft Access Class Not Registered Run-time Error -2147221164 (80040154) Class Not Registered

  1. After experiencing the subject Run-time error, I tried the short repair. This didn’t work. I tried the longer online repair which uninstalled and re-installed MIcrosoft Office 365. This, also, didn’t work. The error occurs in a Microsoft Word template.

Leave a Reply

Your email address will not be published. Required fields are marked *