Offsite users

[Kevin]

I have a form that we want our offsite sales reps to fill out and send to us.
When they 'submit' the form, it should update a local database on their
computer (probably MS Access), AND send a file to our server where it can be
picked up and automatically added to our onsite database (preferrably MySQL,
but MS SQL Server if needed). Is there a way to do this with InfoPath, and
if so, how?

 

[Ben Walters]

Hey Kevin,
This is someting that InfoPath can do very well, there are a couple of
things to take into consideration however
1: You will need to ensure that all your off site staff have InfoPath 2003
Installed locally
2: You need to make sure they have access to the template you create for
caputring data. This template can be accessed through a number of avenues
including via a website or it can be installed locally on their machines via
an msi

As for the solution I would recommend that the form is submitted to a web
service this web service could then take the submitted form and save any
required data directly to your internal database storage system. This also
adds a layer of abstraction to protect your db from any security breaches.

If the user requires that the form be stored locally he or she could save a
copy of the form to their local HDD or alternatly maintain a local data store
like SQL express.

Hope this helps

Cheers
Ben Walters

 

[Bob C.]

Ben,

Do you know of any samples of this (on MSDN perhaps)?

 

[Ben Walters]

Hey Bob,
I don't know of any articles in perticular but I'll try and put a sample up
on my blog in the next couple of weeks. Unless of course I find something
better before then

Cheers
Ben

 

[Bob C.]

I'm sure with Beta2 out, there'll be plenty

Hey Bob,
I don't know of any articles in perticular but I'll try and put a sample up
on my blog in the next couple of weeks. Unless of course I find something
better before then

Cheers
Ben