Hi Fred, LJ, et al., Fred, we're on MS SQL. I see the table name in the View Info tab of the form properties but it gives no clue as to the database & server.
LJ, you suggested the XML version of the table definition would show the old connection. I exported to xml and there is no evidence of the database name or the database server name in the resulting file. I exported workflow database calls to discover the old server name. However, knowing that doesn't help me change it in an ARS-friendly way. Thanks again for any suggestions on where/how to change the view form's target database. Doug Original message: Date: Fri, 20 Jan 2012 22:20:00 +0000 From: "Grooms, Frederick W" <frederick.w.gro...@xo.com> Subject: Re: Moving the database to which a view form links? In the Admin tool the Form Properties -> View Information tab lists the source for the data (in the Table Name field). What database are you using? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson, Doug Sent: Friday, January 20, 2012 3:42 PM To: arslist@ARSLIST.ORG Subject: Moving the database to which a view form links? ** Hi All, I've inherited a view form that points to a table in a non-ARS database. That database needs to move to a different server. I've never had to do this before. This is on ARS 7.1 patch 6. I've looked through the manuals & I see where the path is set when creating a view form. What I don't see is where & how to change that path for an existing view form. I've queried the schema_view table and don't see it there. I've exported a def file and don't see it there. How does one do this? Must I re-create the view form (and everything that references it)? Thanks for any clues, Doug Anderson _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"