[AccessD] Power shell automation

[John Colby]

Look at the following page.  Now replace excel with Access.
https://4sysops.com/archives/excel-macros-with-powershell/

PS C:\Users\jwcol> $Access = new-object -comobject "Access.application"
PS C:\Users\jwcol> $Access.visible = $true
PS C:\Users\jwcol> $Access | gm


   TypeName: Microsoft.Office.Interop.Access.ApplicationClass

Name                      MemberType            Definition
----                      ----------            ----------
AccessError               Method                System.Object
AccessError(System.Object ErrorNumber), System.Object ...
AddAutoCorrect            Method                void AddAutoCorrect(string
ChangeFrom, string ChangeTo), void _Appli...
AddToFavorites            Method                void AddToFavorites(), void
_Application.AddToFavorites()
AppLoadString             Method                System.Object
AppLoadString(int id), System.Object _Application.AppL...
BeginUndoable             Method                void BeginUndoable(int
Hwnd), void _Application.BeginUndoable(int Hwnd)
BuildCriteria             Method                string BuildCriteria(string
Field, int16 FieldType, string Expressio...
BuilderString             Method                System.Object
BuilderString(), System.Object _Application.BuilderStr...
CloseCurrentDatabase      Method                void
CloseCurrentDatabase(), void _Application.CloseCurrentDatabase()
CodeDb                    Method
 Microsoft.Office.Interop.Access.Dao.Database CodeDb(), Microsoft.Off...
ColumnHistory             Method                string ColumnHistory(string
TableName, string ColumnName, string que...
CompactRepair             Method                bool CompactRepair(string
SourceFile, string DestinationFile, bool L...
ConvertAccessProject      Method                void
ConvertAccessProject(string SourceFilename, string DestinationF...
CreateAccessProject       Method                void
CreateAccessProject(string filepath, System.Object Connect), vo...
CreateAdditionalData      Method
 Microsoft.Office.Interop.Access.AdditionalData CreateAdditionalData(...
'
'
'
ReturnVars                Property
 Microsoft.Office.Interop.Access.ReturnVars ReturnVars {get;}
Screen                    Property
 Microsoft.Office.Interop.Access.Screen Screen {get;}
ShortcutMenuBar           Property              string ShortcutMenuBar
{get;set;}
TempVars                  Property
 Microsoft.Office.Interop.Access.TempVars TempVars {get;}
UserControl               Property              bool UserControl {get;set;}
VBE                       Property              Microsoft.Vbe.Interop.VBE
VBE {get;}
Version                   Property              string Version {get;}
VGXFrameInterval          Property              System.Object
VGXFrameInterval {get;}
Visible                   Property              bool Visible {get;set;}
WebServices               Property
 Microsoft.Office.Interop.Access.WebServices WebServices {get;}
WizHook                   Property
 Microsoft.Office.Interop.Access.WizHook WizHook {get;}
--

-- 
John W. Colby
Colby Consulting