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