Gary, I understand the budget crunch !! Solution cost is $4999.00 + support Here is a link for more detailed information. http://www.buoyantsolutions.net/External_DB.html BTW: There are many on the ARS List that use this solution and swear by it ... not at it !! HTH Regards...Gidd
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Dries Sent: Wednesday, April 02, 2008 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: Issues with building a view over a DB Link ** Gidd, I am not in a position to purchase any tool, apps, or anything for that matter. To evaluate something and recommend to management would take longer than I have to resolve this issue. I will talk to my Mgr. to see if he is interested, what is the cost of this solution? Brian, The field mentioned in the error is not the key, the field we have identified as a key is unique, no null and between 6 to 15 characters, that field is not giving us any problems and successfully maps to the view form when it is created. Now the write access issue is another thing I am working on, what I do not understand is the fields that do get mapped in the view form have the same permissions as the fields that error. Fellas, I appreciate the quick response Gary __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"