Windows 10: Power Shell Open Database and Run Macro Error

I have this Powershell script which will open the Access database but will not run the Macro 'Run_Mktbl_PlanID_NetRS': any assistance is appreciated....Thanks...$MsAccess = New-Object -ComObject Access.Application$MsAccess.OpenCurrentDatabase'E:\Source\DATABASE FRONT END FILES - Sample Share\Development\Dev_RS Database Updates - CURRENT.accdb'$MsAccess 'Project.Run_Mktbl_PlanID_NetRS'$MsAccess.CloseCurrentDatabase$MsAccess.Quit

:)

 

Recover access database

Did you try this yet? http://support.microsoft.com/kb/283849

Run the Compact and Repair utility. To do so, follow these steps:

• If the database is open, close it.
• On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
• In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
• In the Compact Database Into dialog box, enter a new file name, and then click Save.
  
  If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.

 

Ez Macros or any other Macro program

Hi Brian,

The issue is quite unclear and too broad for us to distinguish the main reason why you are having challenges/issues in Macro. To have a better understanding of your concern, we'd like to ask you some questions:

• Are you referring on using macros on Excel? If yes, what is the version of your Office?
  
• What exact application are you using when using macros? Where did you download it?

• What were the recent changes made on your computer before you experienced this issue?
• What troubleshooting steps have you done so far?
• Did you receive any error message?

Your response will be much appreciated.

 

Power Shell

power shell found corrupt files and i closed it by error. power shell[adm] will not work now Help Please.