lcconnstr = 'Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;' + ; 'SourceDB=C:\MyDir\Mydatabase.dbc;Exclusive=No;Deleted=No;' + ; 'BackgroundFetch=No;'HTH.
>lconnstr = 'DBQ=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB;'+; > 'DefaultDir=C:\Program Files\Microsoft Visual Studio\VB98;'+; > 'Driver={Microsoft Access Driver (*.mdb)};DriverId=281;'+; > 'FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;' >lnconn = sqlstringconnect(lcconnstr) >>>>This way you can keep the conenction information in a table (or whereever) and add to it as needed.