Thanks Joe, I will try all you said and have you posted tomorrow(I'm out of office at the moment) but I want to point out that will creating the view form I was able to load the table and the pick the fields required for the form. Only when I pressed "Create" the error occurred.
.. and furthermore the ms sql username and password was hard-cored into the public DB link created Victor _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"