InfoPath won't talk to Access after 255 characters. Workaround please?

InfoPath won't talk to Access after 255 characters. Workaround please?

Post by Rachel Gar » Wed, 16 Apr 2008 07:19:25

As early as this morning, I was calling InfoPath my favorite Microsoft
product. That was before I found out that it disables submission of
information back to the database if anything you're reading from it is
too long:

"Submit status: Not allowed - One or more of the columns in the data
source has a long data type (text, ntext, hyperlink or image). Long
data types are not supported."

The "workaround" I see listed, when I Google this text, is that I
should write a web service. I don't have time to learn how before this
work project is due on Friday, and it doesn't seem to me like that
could be the most efficient way to do it. Here are my thoughts:

1) I could convert all the tables in the Access database to XML, and
write my forms again from scratch using the XML documents as the data
source(s). I haven't yet figured out how to submit changes to an XML
data source, just by filling out an InfoPath form. The "submit" button
properties don't seem to allow this.

2) I could forget InfoPath and write a form in Access instead.

3) I could keep the Access data >> InfoPath forms that exist, and
figure out a way to append the data collected in InfoPath into an
Excel spreadsheet, which I then could append to the existing tables in

I feel like I must be doing something wrong, because letting users
interact with data (i.e. read and change it) is exactly what InfoPath
is supposed to do, but I can't seem to make it work for something that
is actually pretty basic -- letting users search for information in a
database and make changes to a couple date fields and a comments

Rachel Garrett

1. Allowing ZoneAlarm to Access DHCP (

2. sqlmangr.exe attempts to access (ZoneAlarm Pro)

I've got SQL Server 2000 installed on my PC but with the services configured
as manual so the server doesn't automatically start up on power up.

But I do have sqlmangr.exe (SQL Service Manager) in startup. Zone Alarm Pro
traps an access to (which it's classing as the Internet).
Anyone know what the server manager is attempting to do here? What is used for as it's a special IP address.

Thanks, Rob.

3. busted workaround for 255 character limit in cells

4. versus

5. inet_addr returns "' in Win2003 OS

6. Urgent : Send a customized DHCP packet form to ?

7. [solved] Problem sending broadcasts to on Vista

8. How to enable udp broadcasting

9. UDP broadcast to

10. single host netmask (

11. invalid subnet mask set

12. subnet mask Assignment

13. Subnet Mask?

14. invalid subnet mask set

15. Default outbound BOOTP permitted (,bootps(67))