>>I think I've done what you said and I am now getting an error that says "FUNCTION NAME MISSING )."
>>
>>Cecil
>>
>>
>>lnConnHandle = SQLSTRINGCONNECT('DSN=MS Access Database;DBQ="'+;
>> lcMDBDir+'\'+lcMDBName+'";DefaultDir='"+;
>> lcMDBDir+'";DriverId=25;FIL=MS Access;MaxBufferSize=2048;'+;
>> 'PageTimeout=5;UID=admin;')
>>
>The quotes after DefaultDir= are reversed.
Well, I reversed the quotes after DefaultDir and it said that the file was invalid:
lnConnHandle = SQLSTRINGCONNECT('DSN=MS Access Database;DBQ="'+;
lcMDBDir+'\'+lcMDBName+'";DefaultDir="'+;
lcMDBDir+'";DriverId=25;FIL=MS Access;MaxBufferSize=2048;'+;
'PageTimeout=5;UID=admin;')