Interaction with a Data Connection

[TheTallOne]

I have an Access Database with one master table, and two detail tables
[inputs and outputs], All relationships are setup.

I created an InfoPath from from these threee tables.

If I fill in the form, I get the expected [generally] XML file saved.

But what I really need to do is directly have the form interact with the
Data Connection.

For this phase of development I do not want to have to develop a Web Service
or other type of mechanism [although that will occur in the future]

Any advice, helpful links or the link, greatly appreciated. Also I can post
the existing DB and form to any interested parties.
Thanks in Advance

 

[Scott L. Heim [MSFT]]

Hi,

If you have indeed created your InfoPath form directly from your Access
database (Create new - from data connection) then by default you will have
the ability to query the data and submit edits/deletes, etc. to the
database.

However, there is one caveat to this: if your tables contain fields with
data types of OLE Object, Memo, etc. then you will not be able to directly
bind to the database and have the ability to submit updates. If this is the
case and you cannot change the data types, you will need to use a web
service to retrieve and update the data.

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.