"Smriti Dev" <sm********@utoronto.ca> wrote
I wanted find out if it is possible to have
many users access an access
database and add records using forms.
"Many" is an imprecise term -- thus you'll need to look below for some
ranges.
I'm worried their might be data
corruption. I will have about 5 users
using the database.
IMNSHO, "5" is not "many"; it is "few".
There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.
Factors in how many users can be supported in multiuser include the
requirements, design, and implementation of the database application and the
hardware, software, and network environments. If all factors are near
perfect, we have reliable reports of over 100 concurrent users. Even if not
all are near perfect, we routinely see reports of 30 - 70 users. But, in
cases where we are rather sure that all are about as far from perfect as can
be, people have reported Access "falling over" with as few as four users.
I'd venture to guess that if someone went out of their way to do
_everything_ wrong, it would be possible to create a database that wouldn't
even support one or two users. <GRIN>
