Changing InfoPath Fields Mapped to MS Access

[fisher.garrett]

I am pretty new to InfoPath. I set up a form linked to an MS Access
database for data entry. I then renamed one field and added a number
more in the Access database. I would like these to appear in the
InfoPath form. For starters, I cannot edit the field name in Infopath
that I renamed (I am in design mode). Secondly, I would like to easily
add these fields. Is there a way to "sync" with the data source
instead of doing this manually?

Thanks for any help!!!!

 

[Chandrakanth (GGK Tech)]

Hi,

Please modify the Access DataBase Secondary connection in your infopath form
when ever you make changes in Access DB. So that the changes that you made in
Access DB will be automatically reflects in your Infopath form.

 

[fisher.garrett]

Hi,

Please modify the Access DataBase Secondary connection in your infopath form
when ever you make changes in Access DB. So that the changes that you made in
 Access DB will be automatically reflects in your Infopath form.

Chandrakanth,

Thanks for the help! Unfortunately, I do not have a secondary data
source. When I first designed the form (months ago), everything worked
fine. It would submit new records to the Access MDB. I went to edit
the same Infopath form after changing some of the fields in Access,
but they have not changed to mimic Access NOR CAN I CHANGE THEM!!! The
option to change the field names is grayed out. Please help!

Thanks again.

 

[Anuma(GGK Tech)]

Hi,

How you are connecting Access database to Infopath form?
can you refresh that connection once.