Opening MS Access database with Powershell?

Question

I am trying to open a form in an access database using powershell:

$application = New-Object -ComObject Access.Application
$Fullpath = "path.accdb"
$application.OpenCurrentDataBase($Fullpath)
$application.docmd.OpenForm("frm")

I am getting the following error message:

Exception calling "OpenCurrentDatabase" with "1" argument(s): "Unable to cast COM object of type 'Microsoft.Office.Interop.Access.ApplicationClass' to interface type 'Microsoft.Office.Interop.Access._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{68CCE6C0-6129-101B-AF4E-00AA003F0F07}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Has anyone seen this before/resolved this issue?

Have you searched around? The error message is extremely specific, you should get some hits. For example stackoverflow.com/questions/3651044/… — Tomalak
– Tomalak, Commented Sep 11, 2018 at 7:50

NoobyBooby · Accepted Answer · 2022-04-27 12:30:21Z

1

A bit late now, but for the sake of following up...

Did you check that your path was what it should've been?

It seems you were trying to open something that was not an access application but an _Application interface object (Word, Outlook, Excel perhaps?)

"Unable to cast COM object of type >'Microsoft.Office.Interop.Access.ApplicationClass' to interface type >'Microsoft.Office.Interop.Access._Application)'.

I would start with something like this:

$Fullpath = "path.accdb"
echo $Fullpath
$application = New-Object -ComObject Access.Application
$application.OpenCurrentDataBase($Fullpath)
$application.docmd.OpenForm("frm")

Better late than never, maybe it helps down the line.

answered Apr 27, 2022 at 12:30

NoobyBooby

437 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nher · Accepted Answer · 2018-09-11 13:59:45Z

0

I want you to try this.. I made this code and its working fine

$Db = "sampledb.mdb"
$cursor = 3 
$lock = 3

$conn = New-Object -ComObject ADODB.Connection 
$recordset = New-Object -ComObject ADODB.Recordset
$conn.Open("Provider=Microsoft.Ace.OLEDB.12.0;Data Source=$Db")

$query = "Select * from LoginInfo"
$recordset.open($query,$conn,$cursor,$lock)

$recordset.Addnew() 
$recordset.Fields.Item("EmpID") = "1" 
$recordset.Fields.Item("UserName") = $username_txt.Text
$recordset.Fields.Item("PWord") = $password_txt.Text
$recordset.Fields.Item("EmpRole") = $userrole_combo.SelectedItem

$recordset.Update()
$recordset.close() 
$conn.close()

answered Sep 11, 2018 at 13:59

Nher

11 bronze badge

Collectives™ on Stack Overflow

Opening MS Access database with Powershell?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related