Infopath - connection to Access database

S

Susan

I am designing a form in Infopath which is connected to an Access database.
Connection setup was fine, Able to add all my fields to the form.
But -
I want to add a button to submit any changes to the database. On the
properties for the button, I choose the action "submit", enable submit
commands and buttons,
then click on the "submit to" drop down, and do not get an option for
database.
Only options are email, web service, sharepoint library, web server, custom
submit using form code and custom submit using rules.

Am I missing something on my connection or the install for Infopath? I
referred to document
http://office.microsoft.com/en-us/infopath/HA011199501033.aspx?pid=CH011097411033 when starting this form.
 
S

Susan

Well I feel like a dodo! You need a primary key on your table in access for
the submit function to be enabled on the data connection in Infopath.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top