Submitting long data types to Access from Infopath
Posted on 2005-03-06
I have designed an Infopath form from a Microsoft Access database. One field I need to submit is a "narrative" field for our officers' incident reports. I have it set up as a memo field in Access, which works perfectly fine. However, Infopath will not submit information to the database because it is a long data type. Is there any type of work-around that will allow me to submit the long data type to the Access database. We do not have access to SQL server, Windows SharePoint, or any other alternatives except for submitting directly to a MS Access database. Is there code that can be written to submit this info? If so, can someone provide me with that code (as I am an amateur with Infopath, let alone writing having never written code)?