Newbie - please help

[Misty]

Can anyone suggest a good book about how to go about integrating Access with
InfoPath? I have been trying to figure out how to get my form to submit and
so far it seems to be impossible, at least I haven't really been given an
answer that has worked yet. And I still don't understand why you can't use
one form to submit to multiple relationship tables.? I made sure that I had
all the correct datatypes in my access db, nothing that wouldn't allow you to
submit. It is just that I have a one to many relationship from what InfoPath
is telling me.

Anyway, I appologize, I am getting frustrated with it, so thought that it
might be good to read a book on it. So any answers or suggestions you have
would be appreciated.

Thanks,

 

[Franck Dauché]

Hi Misty,

Powering Office 2003 with XML by Peter Aitken has one chapter (13) about
Connecting Access and InfoPath. However, I don't think that it will go in
depth enough for what you want....

You may want to look into Web Services to isolate your db from your form.

Regards,

Franck Dauché

 

[Misty]

Thank you Franck, I will definitely check that book out. I may be able to
get some more info for other things that I am trying to do as well. I am
also going to look further into Web Services. I had originally requested it
for this project, but was told that at this time it would not be possible.
Hopefully, with some new info I will be able to convince them otherwise.
I don't know to much about Web Services, do you need any additional software
other then the basic internet explorer and server access? I suppose I can
probably look up that info in past postings too.

Thanks again,

Misty

 

[Franck Dauché]

Hi Misty,

You will need Visual Studio .Net (2003 or the new 2005). You can write Web
Services in C# or VB.Net (same languages you can use behind InfoPath if you
install the toolkit).

Regards,

Franck Dauché