That's it!. The quotes around the filename messed it up.
Peter
PS have you ever used VisualCE to create an application on a PDA (Win CE)
>Try EXACTLY as here:
>
>STORE SQLSTRINGCONNECT(;
>[DBQ=C:\Program Files\Windows CE Services\SYWARE Visual CE\CPR\pac1.mdb;]+;
> 'DefaultDir=C:\;'+;
> 'Driver={Microsoft Access Driver (*.mdb)}');
> TO gnConnHandle
>
>If not succeed, then what does the following return:
>
>?aerror(aa)
>?aa[2]
>
>
>>That is exacly what I am looking for. But
>>SQLSTRINGCONNECT(;
>>[DBQ='C:\Program Files\Windows CE Services\SYWARE Visual CE\CPR\pac1.mdb';]+;
>> 'DefaultDir=c:\;'+;
>> 'Driver={Microsoft Access Driver (pac1.mdb)}');
>> TO gnConnHandle
>>
>>returns -1
>>Maybe the fact that when I get into access (yuck!) from windows a dialog comes up say this file might not be save.... and I have to click on the open button.
>>
>>how can one get around that?
>>
>>Peter
Peter Cortiel