Variable in string

[JohnCR]

Is there a way to use a variable in this string? Something like...

sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ= & applipath(errorlog.mdb)"

Is there a way for 'applipath' to be a variable which would just hold a path to a folder (and .mdb file)?

Thanks in advance,

JohnCR

 

[PHV]

Something like this ?
applipath="\path\to\mydir\"
sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & applipath & "errorlog.mdb"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JohnCR]

That's it.

Thank you,

JohnCR