Using a Web Server to Submit Data to an Access Database

[P Ferguson]

I am a newbie to InfoPath and am considering it as an alternative to some of
our more manual business processes. I feel comftorable in using the UI and
creating new forms with links to an access database, however I am struggling
with how to distribute it. When I send out the forms users cannot use them
because the forms are looking for the database on my pc. We don't have a
central network that everyone could access, so I thought an alternative would
be to host it on a web server but I am not sure what is required. Such as,
What hardware is required? Can I just ftp my access database to the url of my
webserver and link the forms to it? Or do I need to have sql server installed
on my webserver? Any advice/links is much appreciated. Thanks in advance.

 

[SSA]

No, you won't need the SQL server. You can use the Access DB but make sure
that network shares are enabled on your host server because you will need to
access the DB path like \\NetworkFolder\YourDB.MDB and also you will have to
grant permissions to the network folder so that all your users could access
the DB otherwise you will get an error (eg, DB Path not found). Before
putting the form in the shared folder, you will have to enable the full trust
and sign the form digitally.

SSA

 

[Clay Fox]

In my opinion best practice is to have a central SQL server that all of your
forms work with. You can have one of these hosted or setup a dedicated
computer. You may want to check out the Database Accelerator Package. It has
everything you would need once you have a server to locate it to distribute
and organize your forms to your users. It includes work flow, security,
search, etc.
http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com