Quotes and Ampersands

[VBIlliterate]

Hello,
I am trying to open a database from my current database, but am having
trouble with the following line:

call Shell(SysCmd(acSysCmdAccessDir) & "msaccess.exe \\serverX\Tools &
Applications\MyApplication\File1.mdb", vbNormalFocus)

First it says "The command line you used to start Microsoft Office Access
contains an opion that Microsoft Office Access doesn't recognize."

And then it opens another instance of access and says "Microsoft Access
can't find the database file '\\serverX\Tools.mdb'

I know that the ampersand in the folder is causing an error but I cannot
change the folder name--is there any way to work around it?

THANK YOU!!!

 

[Daniel]

VBIlliterate

Try this instead

Shell(SysCmd(acSysCmdAccessDir) & "msaccess.exe " & """\\serverX\Tools &
Applications\MyApplication\File1.mdb""", vbNormalFocus)

Daniel

 

[VBIlliterate]

Perfect--Thank you so much for you fast and accurate answer, Daniel!