Hi Kevin,
Check Borislav's reply Message #
1246223.
>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
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst