Data collection form w/o DB rights - how to do?

[zeon]

We have a need to collect data in a form a write to an SQL 2005 database.
However, the data will be entered by people in deptartments A, B and C, but
we don't want them to have authority to write directly to the database.

Instead we would like to have the data owners in department Y to receive the
data, and write to the database. What is the best & easiest way to do this?

Would it be to have departments A, B and C save their input to an XML file,
and mail that file to Department Y, who would do the actual submit from the
form to the database? We do NOT have Outlook or Exchange so we don't have the
ability to send an email from the form.

Thanks!

 

[Greg Collins]

A custom web service would probably suit your needs.

 

[zeon]

Thanks for the prompt response, I was hoping from something simpler, as I
don't have the option to use a custom web service.

 

[Clay Fox]

Hey Zeon.

I think I might have a solution for your workflow.

You can email me here and we could discuss.
http://www.infopathdev.com/members/clayfox.aspx