I have an existing Access application that I would like to use a PowerShell script to list all of the forms with their associated fields in that application. Is there anyone here that could help me do this?
I believe to get to the forms, you will need to use com objects. If you were just getting data from tables, you could use ADO or OLEDB to connect. You might want to start by looking at the documentation:
Unfortunately all the examples are VBA but once you instantiate the objects in PowerShell, the properties and methods are all the same.
Here’s docs on using com objects in PowerShell.
Thank you. I don’t need to use the COM objects (which I assume Forms are). I just need to list them. I see there is a Instantiating an object like