>Next step, take the same form and change the data source to another dbc also SQL Server 7.0 - on the same box. This is the production data base. It would not work properly and I got desperate - so I went back to ODBC and it worked.
>

bummer...sounds similar to my problem, very difficult to track down

>
>Being a programmer can be so much fun. Well, I am going to take my guitar and go to the flamenco dance class tonight and take out my stress. Beats hitting my head against the wall!
>

In addition to getting rid of stress, maybe you'll have some actual enjoyment. :)