MS Access 2013 query

PowerShell Help
1

Hello,

We use MS Access 2013 and their is a query we want to run automatically.

What is the issue ?

We build a form with a button. When the user click on this button the query, code behind this button, fill-up a table. But the user sometimes forget the push on this button. I’ve read on the internet that you can run this query from PowerShell.

But I don’t know how ?

Let us assume the database name is c:\test\test.mdb.

The query is : q-fillup-tabel

Thanks

2

[quote quote=156851]Hello,

We use MS Access 2013 and their is a query we want to run automatically.

What is the issue ?

We build a form with a button. When the user click on this button the query, code behind this button, fill-up a table. But the user sometimes forget the push on this button. I’ve read on the internet that you can run this query from PowerShell.

But I don’t know how ?

Let us assume the database name is c:\test\test.mdb.

The query is : q-fillup-tabel

Thanks

[/quote]
Yes you can look at this cool example

https://devblogs.microsoft.com/scripting/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script/