Database option not showing in Submitting Forms dialog box

B

Brian

I am trying to create a form using Infopath that will submit data to a
database, however the database option isn't showing in the Submitting Forms
dialog box. According to previous posts in the forum, it is either because I
am using a field such as Memo or Hyperlink, or else I need to test the SQL
Statement (Dean). I don't have any long field types and I tested the SQL
Statement, but still no Database option.
I have created a test Access database with just 2 text fields (50 char) to
see if it will work, but still no Database option.
Does anyone have any more ideas as to why?
 
M

Madhur

Brian said:
I am trying to create a form using Infopath that will submit data to a
database, however the database option isn't showing in the Submitting
Forms dialog box. According to previous posts in the forum, it is
either because I am using a field such as Memo or Hyperlink, or else
I need to test the SQL Statement (Dean). I don't have any long field
types and I tested the SQL Statement, but still no Database option.
I have created a test Access database with just 2 text fields (50
char) to see if it will work, but still no Database option.
Does anyone have any more ideas as to why?
Click to expand...

Hi

In Infopath 2007 you cannot submit to the database if you have choosen
blank template. To allow sumbit to the database, you must choose database
template. See my blog.

Ignore if you are not using Infopath 2007
 
Top