>>
>>constring = "DBQ="+path+filename+";Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS
>>MessageBox(constring)
>>...
>>
>>
>>Are you see correct string?
>
>
>Yes. The message is the same as the full 'constring' that I set -and that does contain the correct path and filename to the Access Table.
>
>Here is the code with the exact path I'm using to test...
>
>
>constring = "DBQ=C:\Progs\ccad07\files\AMW.mdb; Driver={Driver do Microsoft Access (*.mdb)}; DriverId=25; FIL=MS Access; MaxBufferSize=2048; MaxScanRows=8"
>sqlHandler = SQLSTRINGCONNECT(constring)
>select * from data1!MsAccess1
>
Kevin,
even if you are connected to some other DataBase (in your case Access) you can't query it directly. You must use so called SPT (SQL-Pass through) or RemoteViews. Check all topics in HELP thats start with SQL* and all for RemoteViews.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.