I designed an application where a user submits an information request via 
a Web based form.  This form goes to an Access database.  Someone is then 
able to access this database and query information requests through Access 
forms.  The only problem is, a Web based form cannot be submitted to the 
database while the database is open.  Is there any way around this (to 
have the database open while submitting Web based forms) other then making 
a web based interface which queries the information requests.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Kevin Lopert" <klopert@j...>
Subject: [access_asp] have DB open while submitting form


: I designed an application where a user submits an information request via
: a Web based form.  This form goes to an Access database.  Someone is then
: able to access this database and query information requests through Access
: forms.  The only problem is, a Web based form cannot be submitted to the
: database while the database is open.  Is there any way around this (to
: have the database open while submitting Web based forms) other then making
: a web based interface which queries the information requests.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Welcome to the problems of using a database that was never designed as a
database server, but rather a single user desktop database, on the web...

My personal suggestion? Either use the MSDE engine that comes with
Access2000/02 as a backend (using an Access Project) since that will provide
you with better concurrent access handling (but will limit the number of
simulataneous connections), or use a proper database server (like SQL
Server). You can then have your web interface tie directly to the database
server, and still have the Access interface.

Cheers
Ken