I used the Form wizard to build a simple add/edit/delete screen.

It is to edit a remote view to an SQL 2000 table.

In the data enviornment I selected obdc, put in the id & password then tested the connection (all OK).

Everytime I run the form (Do Form XX) then it shows the connection window for obdc and asks for a password. It is just like I had not specified the ID & Password.

I do NOT want to have my program users asked for the ODBC password.