>

>store SQLSTRINGCONNECT(;
>[DBQ='C:\Program Files\Windows CE Services\SYWARE Visual CE\CPR\pac1.mdb';]+;
>	'DefaultDir=c:\;'+;
>	'Driver={Microsoft Access Driver (*.mdb)}');
>	TO gnConnHandle
>
>=sqlexec(gnConnHandle, "SELECT * from table_name", "vfpcursor")
>......
>=sqlexec(gnConnHandle,"UPDATE table table_name ......")
>......
>
>

>
>
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