Error opening file in folder with space in name

[ictflygt]

Hello,

I hope someone can help me with this:

When opening a file, let's say TEST.MDB located in folder D:\FILES\SALES DEPART\ , MSACCESS return the message:

THE COMMAND LINE YOU USED TO START MICROSOFT ACCESS CONTAINS AN OPTION THAT MICROSOFT ACCESS DOESN'T RECOGNIZE.

When clicking OK then next message occurs:

MICROSOFT ACCESS CAN'T FIND THE DATABASE FILE "D:\FILES\SALES.MDB"

It seem that he asumes that the space is a dot.

Is there anyone out there who HAD this problem or knows how to resolve this problem.

Thanks!

[RWSchlatter]

that's a remains from the long ago time where you only had the 8.3 sized filenames that didn't allow a space. The long filenames can have a space character. So when you have such a filename or directory name, then you must place the whole path into double quotes:
"D:\FILES\SALES DEPART\SALES.MDB".
As you found out, the space otherwise stops scanning for the file name and assumes that options will follow on the command line. If you actually need options, place them after at least one space following the quoted path name.
This is Windows standard since Win95.

______________
Regards - Richard