CODEWITHSUNDEEP
ms-access
Paul Z
Paul Z

Reputation: 37

MS Access open error message

When I tried to open MS Access from the command line I got the following error message:

The command line you used to start Microsoft Office Access contains an option that micosoft Access doesn't recognize.

My command is very simple:

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" E:\MonthlyCompAudit\"Audit - Test - Copy.accdb"

If I just run

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"

it works.

After I included the database name, it does not work. The Access file path/name is current, because I verified with dir command.

Upvotes: 0

Views: 1189

Answers (1)

cddt
cddt

Reputation: 549

Your quotation marks are around only the file name, not the entire path. Try:

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" "E:\MonthlyCompAudit\Audit - Test - Copy.accdb"

Source: https://support.office.com/en-us/article/Command-line-switches-for-Microsoft-Office-products-079164cd-4ef5-4178-b235-441737deb3a6

You can include a path, if necessary. If the path contains spaces, enclose it in quotation marks.

Upvotes: 4

Related Questions