Database option not showing in Submitting Forms dialog box Brian 11.07.2006 21:15:02 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? -- Thanks for any help, Brian

Re: Database option not showing in Submitting Forms dialog box "Madhur" <ashu-wipro[ at ]nospam.nospam> 12.07.2006 03:37:28 Brian wrote: [Quoted Text] > 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? 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 -- Madhur Ahuja http://madhurahuja.blogspot.com