Strings in Code

[MEDolin]

I downloaded from a FAQ the following function....

faq_ConnectLink(strTable As String, strSourceDB As String)

The function is basic, Table Name and Path to a db.

It works great when the path is something simple like...

"C:\My Docs\db1.mdb" but, the path I'm trying to use is like...

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\My Documents\db1.mdb" /WRKGRP "C:\My Documents\Secured.mdw"

I need to make the above string a single string.

Any help would be great.

MD

 

[Rob.Mills]

Try this:

""C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\My Documents\db1.mdb" /WRKGRP "C:\My Documents\Secured.mdw""

Double quotes at the beginning and end.

 

[MEDolin]

Tried the Double Quotes at the beginning and ending, but it still does not work. I get...

Complie Error:

Expected: List Operator or )

Any other ideas???

 

[Travis]

You have to double up all of the Quotes not just the first and last.

 

[MEDolin]

Function with double qoutes on each section looks like...

faq_ConnectLink("Employee", ""C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"" ""C:\My Documents\db1.mdb"" /WRKGRP ""C:\My Documents\Secured.mdw"")

Still does not work?

 

[Travis]

Your missing the Outside "

Try This:

"""C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"" ""C:\My Documents\db1.mdb"" /WRKGRP ""C:\My Documents\Secured.mdw"""