Infopath 2003 linking to Access Database.

[wwgmr]

Hi all,

I am new to Info path and was thinking it would be easy way to link to table in Access.
Sofar it seems to be. I am looking for help with this problem or maybe being pointed to great site with information on this in way of step by step guides.

I have Access Database with 3 tables. Customer and Service table plus a state table for looking up state Abb.

I went into Infopath and created new form from access database. It setup very nice all fields I wanted. My problem is there seems to be no link to the database. It seems to be using its own xml table now. How can I have the forms linked to Access so I can modify and change or look up via Query button.

Any help would be great. Thanks

 

[rjblanch]

The only issue I have found is that to modify data in the DB is that it must be the primary data source. I am sure that secondary data sources can only be used to query.