 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / May 2005submit infopath form to access database
i have designed an infopath form and wish to submit it to an access database on my computer. by going to tools>design form>submit... I can use http or a script but i cannot browse to find a database... what to do? also, if i try to import the XML infopath-generated form directly into access by using Get External Data command, i get erros I think I have a similar problem. I just started teaching myself InfoPath. I've been able to create forms for SQL Server databases without any problems. However, for some strange reason when I create a form for Access the 'Submit' command is disabled most of the time. Anyone have an answer? Thanks in advance, > i have designed an infopath form and wish to submit it to an access database > on my computer. by going to tools>design form>submit... I can use http or a [quoted text clipped - 6 lines] > access by using > Get External Data command, i get erros Hi Nate, If you have designed your InfoPath solution from an Access or SQL Server database and you do not have the option to "Submit" to a database, it sounds like your table may have "long value' types of fields, such as: OLE Object, Memo, etc. If you have to have these types of fields, you will need to write custom code to perform the submit functionality. This is not "InfoPath" related per sé but more "ADO/OLEDB" related, which is the underlying technology InfoPath uses for accessing data. I hope this helps! Best Regards, Scott L. Heim Microsoft Developer Support This posting is provided "AS IS" with no warranties, and confers no rights Hi, If you want to create an InfoPath solution that will submit to an Access or SQL Server database, then you need to begin designing your solution from one of those databases. It sounds like you may have chosen to "Create a new blank form", created the form as you need and now want to submit to an Access database. It's not possible to have InfoPath create a database schema from your InfoPath solution so you need to design your solution "from" one of those databases. I hope this helps! Best Regards, Scott L. Heim Microsoft Developer Support This posting is provided "AS IS" with no warranties, and confers no rights |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.