Sorry this also didn't work. I guess I will stay back with ODBC for the time being <g>, I know you told me so <bg>.

Thanks for all your help.

>
>It's 'ENGINEBEHAVIOR=70'. I tried but didn't work. OK try this one sounds to be working :
>

>oConn = NewObject('ADODB.Connection')
>with oConn
> .ConnectionString = 'Provider=VFPOLEDB.1;'+;
> 'Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;'
> .Open
> .Execute('SET ENGINEBEHAVIOR=70')
>endwith
>

>Then call your report manager routine as before.
>I haven't tried this within in an exe but in development mode when I do this once and then close the connection (and even close all, clear all etc.), any connections after that behave as 'ENGINEBHAVIOR=70'.
>Cetin