>Thanks for these two quick replies. I feel the answer is staring me in the face now, but I'm still not seeing it.
>
>I don't know why, but I still get the automated 'Select Database' messagebox asking me to locate the MDB table with the following (stripped down) code...
>
>
>
>constring = "DBQ=<path&filename>;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8"
>
>sqlHandler = SQLSTRINGCONNECT(constring)
>select * from data1!MsAccess1
>>
>note:
>path&filename _is_ correctly pointing to the mdb.
>databasename is data1
>remote view is called MsAccess1
constring = "DBQ="+path+filename+";Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS
MessageBox(constring)
...Are you see correct string?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
