InfoPath Dev

Anyone know a workaround to InfoPath's limitations to only except vchar(8000) data type for a text field?  Anything larger like vchar(MAX) InfoPath thinks that it is a long text type object and doesn't allow the form to submit correctly.  How do I allow InforPath 2003 with a main data connections to a SQL Server 2005 table to ...

I now have perspective.  Thanks.

Was wondering if anyone here had any expereince viewing xml files on their Blackberrys.  Our last form was designed using PDF and some people got used to being able to view the form on their Blackberrys.  Any feedback in this regard would be appreciated.  Thanks,

What is considered to be a large InfoPath template?  I have one that is 1.7 MBs in size, contains 12 data connections (mostly emails) and a ton of data fields (most are not database related).  Everything works fine, just was curious about this.  Thanks.

You are correct with that statement Anuma because I have expereinced it first hand.  As far as I know this can't be done.  I would like to be able to only because I feel that it doesn't need to be there for majority of the users.  It would make it even more user friendly. 

Thanks for replying to this post. First, we are not using SharePoint directly.  The form is connected to a SQL DB, publised to a shared folder on a network drive and only the link is placed on a company SharePoint webpage.  For me, the only way the ADO pop ups can be avoided is when I add the name of the server (//example) as a trusted ...

After some troubleshooting, I figured it out.  The error was not too much of help, but I ended up re-connecting my data connections and it ended up working.  Thanks to everyone who read the post.

Thanks everyone for your inputs.  I ended up testing it out and InfoPath doesn't have any limitations really.  My SQL data type was set at varchar8000 and InfoPath handles it just fine.  That is good news.

First, thanks for the reply.  This is an issue.  The nature of this form revolves around a job intake process which admins update with progress notes.  Is there any workaround to this?

I wanted to verify something regarding published forms. I have a form that I need everyone in the company to be able to access from all locations. I have published it to a folder on a server and added that server as a trusted site in IE. It works nicely.  So, I have asked my IT group to push this IE setting down to all users, but when they ...