Name change on a SQL Server Table

[mdsmitty]

I have several tables for some of my form solutions and in an effort to
better organize a large SQL Server DB I'd like to change the names of some of
my tables so they are listed together in the DB. I have done this with one
of my forms and it proved to be a lengthy process having to rebind every
field/control on the form. Is there a better way to do this? I am not
changing the DB, column names, or location of anything, just the table names
within the DB.

Thanks
Smitty

 

[Franck Dauché]

Hi,

The best would have been to use a Web Service between your DB and the IP
form. Any change within the DB or even any change of DB type would be
transparent to the form.

Franck Dauché

 

[Michael K.]

current virsions of InfoPath are not gracefull when it comes to changes is
data sources, wether it is change in location or their schema.
"When you design a form, Microsoft Office InfoPath 2003 assumes that the
form's data source is in it's final state. InfoPath doesn't adapt to changes
in the form's data source. This article discusses how to update the data
source information in your form when the source schema changes."

One dangerouse, option for you is to manualy modify componets of XSN
(manifest, schemas, xslt, template). The complexety of those modifications
could vary based on what was changed.