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
Access.

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
field.

Thanks,
Rachel Garrett
 
 
 

1. Allowing ZoneAlarm to Access DHCP (255.255.255.255)

2. sqlmangr.exe attempts to access 255.255.255.255 (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 255.255.255.255 (which it's classing as the Internet).
Anyone know what the server manager is attempting to do here? What is
255.255.255.255 used for as it's a special IP address.

Thanks, Rob.

3. busted workaround for 255 character limit in cells

4. 255.255.255.0 versus 255.255.252.0

5. inet_addr returns "255.255.255.255' in Win2003 OS

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

7. [solved] Problem sending broadcasts to 255.255.255.255 on Vista

8. How to enable 255.255.255.255 udp broadcasting

9. UDP broadcast to 255.255.255.255

10. single host netmask (255.255.255.255)

11. invalid subnet mask set 255.255.255.255

12. 255.255.255.255 subnet mask Assignment

13. 255.255.255.255 Subnet Mask?

14. invalid subnet mask set 255.255.255.255

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