Sharepoint with Infopath & Access Database

[JB]

Hi All,

I'm trying to get together an infopath form which can query and submit data
to an access database. This works fine in standalone form but when it comes
to publishing it to Sharepoint my whole plan gets turned upside down as
Infopath on Sharepoint doesn't allow direct submitting to a database.

I've gathered that a web service is the right way to go about this but
haven't been able to work out the hows and whys more than that.

Can anyone point me to a good resource or give me some pointers?

 

[theresa.haynie]

Hi All,

I'm trying to get together aninfopathform which can query and submit data
to anaccessdatabase. This works fine in standalone form but when it comes
to publishing it to Sharepoint my whole plan gets turned upside down asInfopathon Sharepoint doesn't allow direct submitting to a database.

I've gathered that a web service is the right way to go about this but
haven't been able to work out the hows and whys more than that.

Can anyone point me to a good resource or give me some pointers?

Did you get any help with this? I have an access database on a company
server, and a simple infopath form on the Sharepoint site here. I've
struggled with some issues, but if I create the form built from the
database, versus creating a form, and then trying to link to,
everything seems to work.

I don't think that webservices work with Access and Infopath....at
least I believe that in the 2003 version.
Let me know if I can help more.