Your last recommendation works! My sincerest thanks. The area where it shows a drop down arrow remains the same, with 2 entries:
[1: pwsh] and [2: Powershell Integrated Console]. However, when I run my scripts it always goes to [pwsh.exe] regardless of what this field says.
I am however discovering that Powershell Core 6.1 (i.e., pwsh.exe) is missing a few things. For example, I am getting an error message on an old script which runs perfectly well under Powershell ISE (i.e., Powershell 5.1).
This script requires using OLE:
$connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$AccessFile;Persist Security Info=False"
$conn = New-Object Data.OleDb.OleDbConnection($connStr)
In case you happen to know the syntax for loading the assembly that the statement
requires, I’d appreciate some assistance. In any case, I am highly grateful for your patience and kind assistance.