Please can someone help me with this subject.

I have created a remote view and now I am trying to determine how to run the view unattended. I open the database and then open the tables one at a time. The problem is that I have to enter a password for every table that I open (use). I reviewed (configue) the ODBC connection but the password does not have a save password box to check. It disappears every time I enter it and exit and review to see if it is there.

What is the proper way to set up a remote view and run it unattended. I 'am now using the windows 98 task scheduler.

Thanks
Roland