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.