>lcMDBDir = "C:\Program Files\Star" >lcMDB = "The.MDB" && Example only. >lnConnHandle = ; > SQLSTRINGCONNECT('Driver={Microsoft Access Driver *.mdb};DBQ="'+; > lcMDBDir+'\'+lcMDBName+'";UID=admin;Pwd=;') >>
lcMDBPath = "C:\Program Files\Microsoft Office\Office\1033\FPNWIND.MDB" lnConn = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=' + lcMDBPath + ';Exclusive=1;Uid=admin;Pwd=') =MESSAGEBOX(lnConn) ?SQLEXEC(lnConn,'select * from Customers','crsTest')and it worked just fine.