General

Re: infopath form imported to Access

jay.whittaker — Mon, 05 Sep 2005 02:40:45 GMT

I am not sure what you mean by roundtrip. But it is mentioned in the Microsoft developer network that Infopath has a limitation. It only likes text (char) field up to 255 characters. Nothing more. It didn't seem access specific.

-- Jay Whittaker --

Re: infopath form imported to Access

Patrick Halstead — Fri, 26 Aug 2005 07:18:20 GMT

For long data types, why not just roundtrip a BASE64 string representing the data type? We roundtrip images and rich text to SQL all the time. I don't understand this long data type limitation. Is this something peculiar to Access?

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: infopath form imported to Access

cnjiwaji — Thu, 25 Aug 2005 13:14:51 GMT

Thank you Jay for the information. Since I have memos and pictures in my database, I think I'll stick to using Access to create the form.

Thanks, Chantel.

Re: infopath form imported to Access

dominic — Thu, 25 Aug 2005 06:34:18 GMT

I agree Jay, I initially wanted to store mail objects in Access and eventhough access has an onject type for fields it doesn't work. :-(

Re: infopath form imported to Access

jay.whittaker — Thu, 25 Aug 2005 06:24:58 GMT

The benefit of using Infopath includes the ability to submit to a form library, web service or email as well as the database when creating or editing records. Also, infopath allows people to fill out the form when offline and submit to a remote database.

However the downside is, Infopath is unable to handle long data types. That is, if you need to input memo, hyperlinks, or picture data types, Infopath will not submit to the database. This can sometimes be a major and bewildering limitation

-- Jay Whittaker --

Re: infopath form imported to Access

dominic — Thu, 25 Aug 2005 02:37:04 GMT

It might be possible but why not just create the form in infopath and then link it to the Access database for submission and retrieval of information. Thats how I'm doing it and it works well.

infopath form imported to Access

cnjiwaji — Tue, 23 Aug 2005 02:25:06 GMT

I am using Access 2003 to create a database and a user interface (data entry form) for the database. Instead of using Access to create my form, is it possible to use InfoPath and import the form to Access using it as my user interface? If this is possible, how do I do it?

Chantel.