MS Office – Access/Excel – “Missing Excel 16.0 Object Library”

Background

Our users started having problems using a homegrown Microsoft Access Application.

Error

Error Image

microsoftexcel16objectlibraryismissing.20190104.0107pm

 

Error Text

MISSING : Microsoft Excel 16.0 Object Library

 

Trouble Shooting

We have Microsoft Office 2010 installed.

Being sought for “Microsoft Excel 16.0 Object Library“….

BTW, Excel 16.0, is Office 2016.

Remediation

Install Microsoft Office Interop Component.

Microsoft Office Interop Component

Version

Office 2010

For Microsoft Office 2010, the Interop product is available here :-

Microsoft Office 2010: Primary Interop Assemblies Redistributable
Link

Office 2016

The Interop Component not available as a standalone product.  One needs the entire Office suite.

Microsoft Office Suite

Install

As I tried installing Microsoft Office 2016 ran into a blocking issue :-

Image

wecantinstallthe32bitversionofoffice

Text

We can’t install the 32-bit version of Office because we found the following 64-bit programs on your PC :

Microsoft Office Access Runtime 2010
Microsoft Office Office 32-bit Components 2010

Uninstall

Uninstall – “Microsoft Office Office 32-bit Components 2010”

Help
  1. Microsoft Office Office 32-bit Components 2010
    Link
Command

MsiExec.exe /X{90140000-0043-0000-1000-0000000FF1CE}

Confirmation

microsoftofficeoffice32bitcomponents2010.20190104.0137pm

 

Uninstall – “Microsoft Office Access Runtime 2010”

Help
  1. A guide to uninstall Microsoft Office Access Runtime 2010 from your system
    Link
Command

MsiExec.exe /X {90140000-001C-0000-0000-0000000FF1CE}

Confirmation

microsoftofficeoffice32bitcomponents2010.20190104.0137pm

 

Microsoft – Access Database Viewer

Background

Have a database that I need to review.

Unfortunately it is a Microsoft Access Database and I do not have Access installed.

And, so googled for opportunities.

Sample Databases

You likely want to try things out against sample databases before hand.

Here are some sample databases that are available online.

  • Microsoft Office Access 2010
    • Links
      • Download Sample Databases
        Link

 

Tools

Here are some sample databases that are available online.

  • Online
    • Maklabu GmbH
      • MDB Opener
  • Desktop
    • Alex Nolan
      • MDB Viewer Plus

Error :- The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write its data.

Background

Debugging an application and thankfully I have managed to add good exception handling.

Error

Here is the error message :-

Error Image

err_20181203_0532PM

Error Text


Attempt to connect to Provider = Microsoft.ACE.Oledb.12.0;User ID = Admin;Data Source=\\hrdb\payroll\payroll.mdb failed.
Exception Type is System.Data.OleDb.OleDbException
Exception Message is The Microsoft Access database engine cannot open or write to the file '\\hrdb\payroll\payroll.mdb'. It is already opened exclusively by another user, or you need permission to view and write its data.
Error Code is -2147467259
Error Source is Microsoft Access Database Engine
Error Inner Exception is
Stack Trace is at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at intc.svc.timer1_Elapsed(Object sender, ElapsedEventArgs e) in C:\\Service1.cs:line 339

Remediation

I watched the connection string over and over.  Installed the Database Connectivity driver and no good.

Finally, I accepted the error message.

Error Message :-

The Microsoft Access database engine cannot open or write to the file ‘\\hrdb\payroll\payroll.mdb’. It is already opened exclusively by another user, or you need permission to view and write its data.
Error Code is -2147467259.

The keyword is need permission to view and write.

The contextual user did not have the permission needed.