Infopath 2003 Submitting to MS Access not allowed: Longs

[n.repole]

When I try to set up a dataconnection with my MS Access database,
Infopath tells me that submitting won't be allowed because my Access
database has fields in it which are Longs. Now, Access doesn't have
many field type options, and both Memo and Text appear to be longs, so
does that mean there's no way to submit a text field to an access
database?

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

This is an unfortunate limitation with Infopath. You need to use webservice
between your form and DB to overcome this

 

[n.repole]

Hello

This is an unfortunate limitation with Infopath. You need to use webservice
between your form and DB to overcome this
--
Kalyan G Reddy - INFOPATH MVP 2007http://www.ggktech.com





- Show quoted text -

So if I want to use Access as my Data Connection, I can't have any
fields in Access which feature anything that involves characters other
than numbers? That just doesnt seem like it can be true to me.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

You can use the text data type which has character limitation of 255
characters
Make sure to exclude long data types, including Memo and Hyperlink.
This is the limitation set by the Infopath. so you use webservice which will
overcome this limitation

 

[n.repole]

Hello

You can use the text data type which has character limitation of 255
characters
Make sure to exclude long data types, including Memo and Hyperlink.
This is the limitation set by the Infopath. so you use webservice which will
overcome this limitation

--
Kalyan G Reddy - INFOPATH MVP 2007http://www.ggktech.com






- Show quoted text -

Ah. I coulda sworn that the message infopath gave me while trying to
set up the connection said the Text field was a long as well...but
obviously I misread something there. Thanks for the help.

On an unrelated note, on each of my forms I have a reference ID box.
Is there a way to make that field equal to the last number in the
referenceID field in my Access database+1 (so that the form would
incriment it's referenceID by one each time it's opened)?

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Please read the links below where this issue is addressed
http://www.infopathdev.com/forums/thread/5274.aspx
http://www.infopathdev.com/forums/thread/16771.aspx

Also you can search on this site , there are many posts relating to it

I hope it will be helpful