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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Persaud - 08 Nov 2004 16:01 GMT

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.

Signature

Dan Persaud

Reply to this Message

Andrew Watt [MVP - InfoPath] - 08 Nov 2004 16:46 GMT

>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
[quoted text clipped - 3 lines]
>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

Reply to this Message

Dan Persaud - 08 Nov 2004 17:39 GMT

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.

> >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
[quoted text clipped - 11 lines]
> Andrew Watt
> MVP - InfoPath

Reply to this Message

Andrew Watt [MVP - InfoPath] - 09 Nov 2004 09:04 GMT

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

>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
[quoted text clipped - 15 lines]
>> Andrew Watt
>> MVP - InfoPath

Reply to this Message

Scott - 09 Apr 2005 03:53 GMT

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

> Dan,
>
[quoted text clipped - 31 lines]
> >> Andrew Watt
> >> MVP - InfoPath

Reply to this Message

ChrisL - 11 Apr 2005 17:20 GMT

> Andrew,
>
[quoted text clipped - 43 lines]
> > >> Andrew Watt
> > >> MVP - InfoPath

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?

Reply to this Message

Josh - 19 Apr 2005 15:29 GMT

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.

Reply to this Message

Alex [MSFT] - 10 May 2005 17:49 GMT

This is correct - in order to be able to configure Submit to a database,
you need to start off with a database - so start with "New from data
connection".

Good luck,
Alex @ Microsoft

-----Original Message-----
From: Josh [mailto:joshua.carle@pnc.com]
Posted At: Tuesday, April 19, 2005 7:30 AM
Posted To: microsoft.public.infopath
Conversation: Why can't I see dubmit to database as an option?
Subject: Re: Why can't I see dubmit to database as an option?

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.

Reply to this Message

Nathan - 25 Apr 2005 09:48 GMT

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

> > Andrew,
> >
[quoted text clipped - 48 lines]
> database, but not some of the others. What needs to be set in terms of
> sql server roles?

Reply to this Message

nwm - 10 May 2005 02:06 GMT

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

> Just make sure :
> 1. The table (for that data connection) must have Primary Key
[quoted text clipped - 58 lines]
> > database, but not some of the others. What needs to be set in terms of
> > sql server roles?

Reply to this Message