SQL Database Integration

Re: Parse this error: "Multiple colons are not allowed in a name"

Greg Collins — Fri, 11 Apr 2008 17:42:22 GMT

Great thoughts--thanks for sharing them. Kerplunk, let us know if this fixes your issue.

Re: Parse this error: "Multiple colons are not allowed in a name"

bdijkgraaf — Fri, 11 Apr 2008 07:52:33 GMT

I had the same error but solved it. :)
My Access table had a few fields with (very) long names and some spaces in it. I replaced all spaces by underscores and shortened some names.
After that I could submit again.

Re: Parse this error: "Multiple colons are not allowed in a name"

Greg Collins — Tue, 01 Apr 2008 16:46:24 GMT

Thanks! Sorry I couldn't be of more help.

Re: Parse this error: "Multiple colons are not allowed in a name"

kerplunk — Tue, 01 Apr 2008 13:47:03 GMT

Thanks, Greg. I'll give that a try. When I've done some more testing I'll post back with the results in case anyone else runs into similar problems.

Cheers

Re: Parse this error: "Multiple colons are not allowed in a name"

Greg Collins — Mon, 31 Mar 2008 22:56:03 GMT

My suggestion to check with an Access newsgroup/forum was not to suggest that it was a problem with that application, just that someone with a core understanding of that application (with some InfoPath background) might have more insight as to the cause/source of the issue.

Anyone else with ideas -- feel free to jump in at this point.

Good luck!

Re: Parse this error: "Multiple colons are not allowed in a name"

kerplunk — Sun, 30 Mar 2008 23:34:50 GMT

Yes, I've tried that, and I'm stumped as to why the problem continues. I feel pretty confident -- based on the error -- that this is an InfoPath problem and not an Access one. But, when I have some free time I'll try building a simple one-table, 30 column mdb and see what happens.

In the mean time, if anyone else can shed some light on the problem, please jump in.

Cheers

Re: Parse this error: "Multiple colons are not allowed in a name"

Greg Collins — Fri, 28 Mar 2008 23:45:00 GMT

Its probably a runtime issue.

Try building out a new blank form as minimally as possible to do the same submit and see if it persists in the new form. If not, there's something else wrong in your current form. If it does, maybe contact an Access newsgroup/forum to see if anyone there has an idea.

Re: Parse this error: "Multiple colons are not allowed in a name"

kerplunk — Fri, 28 Mar 2008 12:52:19 GMT

No. It apparently makes no difference -- I've tried numerous combinations to see if the problem could be further isolated. From the error I had guess that something was causing IP to generate a generic identifier with an extraneous colon along with the gi's namespace identifier. However, I've exported the contents of the form and if there is such a problem I haven't been able to find it in the markup.

Other ideas?

Thanks

Re: Parse this error: "Multiple colons are not allowed in a name"

Greg Collins — Thu, 27 Mar 2008 23:12:38 GMT

Does it matter which column you remove? Will removing any do (first, middle, last)?

I've not done much work with Access in InfoPath, but I would not imagine such a limit existing.

Parse this error: "Multiple colons are not allowed in a name"

kerplunk — Thu, 27 Mar 2008 17:40:40 GMT

I am using IP 2003 (sp1) to design a form that integrates with an Access DB. Recently, the form processor began to throw the following error on Submit: "Multiple colons are not allowed in a name". In trying to isolate the problem I have gone so far as to recreate both the form and the DB -- grrr. This seems to be the key -- one of the tables has 30 columns. When I remove one of those columns (any of them) the form is processed normally. When add a thirtieth column it throws the error.

Surely there is no such limit, at least not such a slight one. Right? Ideas are appreciated.