>>>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;')
>
Did you try the other connection string?
If it's not broken, fix it until it is.
My Blog