Change Database Location

[Shannon]

We have recently upgraded our servers at work and moved the location of our
access database used to pull the information for info path. Is there a way
to reconnect the database to the form or do I need to create an entirely new
form?

Thanks!

 

[knechod]

We have recently upgraded our servers at work and moved the location of our
access database used to pull the information for info path.  Is there a way
to reconnect the database to the form or do I need to create an entirely new
form?

Thanks!

I am not an expert, but try looking at the Tools menu under "Data
Connections".
You might be able to edit your data connection to point to the new
location.

However, I just emailed myself my forms and database from my home
computer
to work, and I cannot get the form to work, even after running the
Data Connection
change. It has told me either that it can't find a file in the forms
cache, or that
it can't find manifest.xsf.

What am I missing here?

Thanks,

Kevin

 

[Ben Walters]

Hey Shannon,
you shouldn't need to rebuild your form if you open your Data Connection
list you can re-point your existing data connection to the new location of
the Access Database,
if you need more info let me know and I'll shoot some steps through

Cheers,
Ben Walters

 

[Joe]

Hi Folks,

I am experiencing similar problems:
Our development guys do not allow experimental databases / systems on
operational servers and expect us to rollout a fully developed system
(database and accompanied Infopath forms). Alas, I can't seem to get
it right.

Regards

 

[Shannon]

This was actually very helpful! While I did have to go back through and
rebind everything to the new controls it took me about 10 minutes, where
building a new form probably would have taken me about an hour!

Thanks a ton!

 

[Joe]

Hi Folks,

I am experiencing similar problems:
Our development guys do not allow experimental databases / systems on
operational servers and expect us to rollout a fully developed system
(database and accompanied Infopath forms). Alas, I can't seem to get
it right.

Regards

Hi there,

I have about 15 connections used for lookups. When I redirect my
database I have to basically do everything all over again (reconnect
and in most cases re-establish fields involving a lot of dev. time).
Any suggestions?

Joe

 

[Ben Walters]

Hey Joe,
Are you using IP 2007 and SharePoint? if so then you can setup a
dataconnection library and export your connections to XML files all you have
to do then is update the data connection files and not the form