Access to Data Source (Leo Asked)

[Leo]

Hi helpers,
I have a plan to put my MS Access file on a network's folder, and build a
form distributed to everyone in the office, and gather information linked to
that MS Access file which noone except me has any access to the file.
the question is that;
Is it possible for everyone to send their data through submitting the
infopath form , to my MS access file, while they dont have any network access
to it??!

 

[K.Ramana Reddy(GGK Tech)]

Hi,

It is not possible to submit the data when there is no network access.

 

[P Ferguson]

On a similar topic, is it possible for users to complete forms in an offline
version and then submit when they are connected to the database?

Here is my situation:

I have a form (InfoPath 2003) connected to MS Access that I would like
others to complete and then send back to me via email. I will then submit the
data to the database myself. However, when I send the form to someone who
does not have access to the database they recieve an error message saying the
form cannot connect to the database. How do I get around this? Thanks in
advance.

 

[David Dean]

Since the users won't have direct access to the DB, the form will have to
submit the data in some other way (i.e. via a web service or an email
adapter).

Here are a couple of possible approaches:
1. Use an email adapter to submit to a shared mailbox. You can collect all
the forms from the mailbox into one directory, then use the Merge Forms
functionality to pull all the data together into one big form, then submit
from that form.
2. Write a custom web service method that your form submits to. The web
service can be configured to allow update permissions to the database even if
the users do not have these permissions.