>Dear Experts,
>
>I use following procedure to connect MS Access database, this work fine in the directory shown in code as e:\asoft\db1
>
>

>public myconnection
>myconnection = sqlstringconnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=e:\asoft\db1;Uid=admin;Pwd=")
>* db1 is mdb name
>sqlexec(myconnection,"select * from table1", 'cursor1')
>
>if myconnection>0
>	thisform.label5.caption="Connected"
>else
>	thisform.label5.caption="Not Connect"
>endif
>

>
>How to adjust following path
>
>path1=Sys(5)+Alltrim(Sys(2003))
>
>I try to use this line but it displays error
>
>path1=Sys(5)+Alltrim(Sys(2003))
>myconnection = sqlstringconnect("Driver={Microsoft Access Driver (*.mdb)};Dbq="+path1+"\asoft\db1;Uid=admin;Pwd=")

TEXT TO lcString NOSHOW PRETEXT 15 TEXTMERGE
     Driver={Microsoft Access Driver (*.mdb)};Dbq=<<Sys(5)+Sys(2003)>>\asoft\db1.mdb;Uid=admin;Pwd=
ENDTEXT

myconnection = sqlstringconnect(lcString)
IF ....