[RESOLVED] MS ACCESS Error: Command Line Contains an Option Microsoft Access Doesn't Recognize

[vb6forever]

If I go into ACCESS itself, then find the mdb file, I can open it.
However, if I click the mdb file I get the error.

The Command Line you used to start Microsoft Access Contains an Option Microsoft Access Doesn't Recognize

================
There are NO command line options being used.
This is an really old version of ACCESS.
The path to the mdb is really long.
Could it be the error relates to the long Path length?

[fafalone]

Just how long is the path? If it's longer than 256 chars then yeah if Access is old enough it might lack long path support. Then check the actual verb used... maybe it *does* have a command line argument for some reason, like it would if you had Access 2021 installed where the shell open command that fires on double click is actually "path\MSACCESS.EXE" /NOSTARTUP "%1" %2 %3 %4 %5 %6 %7 %8 %9

In the registry, under HKEY_CLASSES_ROOT, .mdb or Access.MDBFile; shell\command\open

[vb6forever]

fafalone: Thanks for responding.

Good idea!
Checked registry under:
1) HKEY_CLASSES_ROOT .mdb shows > Access.Application.8
2) HKEY_CLASSES_ROOT Access.MDBFile > does Not exist,
however Access.MDEFile and Access.MDEFile.8 listed (not sure what an MDE is) but nothing under shell in those listings

Path Count =43

[fafalone]

Ok the shell commands should be under HKEY_CLASSES_ROOT\Access.Application.8 then (when the extension just has another name like that, it will always be in that path).

[vb6forever]

Under: HKEY_CLASSES_ROOT\Access.Application\shell\open\command

only thing showing is:
Path_to_Access %1
%1 should be just the DB file name placeholder.
So nothing unusual ?

[OptionBase1]

Under: HKEY_CLASSES_ROOT\Access.Application\shell\open\command

only thing showing is:
Path_to_Access %1
%1 should be just the DB file name placeholder.
So nothing unusual ?

It should *probably?* be "%1" so that paths with spaces in them will be treated as a single path and not a series of "space delimited parameters".

[vb6forever]

OptionBase1: Thanks for responding

1) We see if that path, OR any of the other paths have spaces, as all other MDBs open OK.
2) If so, we adjust to "%1" and give it a try.

[vb6forever]

RESOLUTION:
The path was DBase-Test.
Changing it to DBaseTest resulted in a resolution.

Thanks all who responded.