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=")