Why can't I see dubmit to database as an option?

[Dan Persaud]

I created an Access database of a couple fields. All I want to do is just
have the user fill a form and submit the data to be stored in my access
database. When I click on button and go to the properties for submit I'm not
seeing database as an option. I succesfully created a form that submits to an
access database before. But for the life of me I cannot figure out why I
can't see the submit to database as an option. This is an easy one but I
cannot figure this one out.

 

[Andrew Watt [MVP - InfoPath]]

I created an Access database of a couple fields. All I want to do is just
have the user fill a form and submit the data to be stored in my access
database. When I click on button and go to the properties for submit I'm not
seeing database as an option. I succesfully created a form that submits to an
access database before. But for the life of me I cannot figure out why I
can't see the submit to database as an option. This is an easy one but I
cannot figure this one out.

Dan,

If you preview the form is there a Submit button in the toolbar (top
left of screen somewhere)?

Andrew Watt
MVP - InfoPath

 

[Dan Persaud]

Actually my problem is making the button work. I cannot get submit to
database as an option. I can create the form just fine from the Access
database. But I cannot grt the option to submit to the database.

 

[Andrew Watt [MVP - InfoPath]]

Dan,

I assume that you are using SP1.

1. Add the button to the form.
2. Right click on it and select Button Properties
3. On the General tab select from the Action dropdown "Submit"
4. You want to submit to a database so just click OK probably on the
next window
5. Click OK again

You should be good to go, I think.

Andrew Watt
MVP - InfoPath

 

[Scott]

Andrew,

I have the same problem as this previous post. I established a data
connection to an existing Access database and I added the database fields to
the form. I then tried to create submit following the intructions from the
help menu but I do not have the database option when I "enable submit". I
followed everything in the thread and I still don't get the database option.

Is there a solution for this problem? I'm using SP1.

Scott

 

[ChrisL]

Andrew,

I have the same problem as this previous post. I established a data
connection to an existing Access database and I added the database fields to
the form. I then tried to create submit following the intructions from the
help menu but I do not have the database option when I "enable submit". I
followed everything in the thread and I still don't get the database option.

Is there a solution for this problem? I'm using SP1.

Scott

I have the same problem, and I suspect it is a security role/user
issue. The 'submit to database' option is available in the northwind
database, but not some of the others. What needs to be set in terms of
sql server roles?

 

[Josh]

I believe this also has something to do with how you create your form.
To submit data to an access database, *I think* you must "Create form
from data connection". I had the same problem, because I needed my
form to query a database and save to one, and I used the "Create new,
blank form" option.

 

[Nathan]

Just make sure :
1. The table (for that data connection) must have Primary Key
2. You have Data Connections type : Retrieve and Submit to database

at least that works for me... =)
(I do hav same problem like all of U guys several days a go)


cheers,
Nathan

 

[nwm]

Where did you go to set the form to 'Retrieve and Submit'?