>naomi
>
>maybe i am not able to explain but i think the problem is elsewhere,
>
>if i choose default data session instead of private and select the tables instead of using them , the program worrks perfectly.
>
>so i am missing something somewhere.
>
>at present the data does not update for some reason even if i close the form and reopen it.

Do you open your tables in Form's Load with USE commands? I'm not sure why would you have this problem with private DS.