building multiuser databases

  • Thread starter Thread starter s
  • Start date Start date
S

s

I need to develop a multiuser database application to be used by four
people(The number of users are not likely to increase). It is for
storing records of different versions of particular papers. I am new to

building such an application. I would like to know what would the
requirements be for using Access as the means for building the
multiuser database. Two of the four use Access 2000(running Windows 98)

and other two use Access 2003(running Windows 2000). Can any one
machine serve as server to host all queries from the users or do I need

another machine to act as the server for the queries(if so please let
me know what OS should it use).

I would appreciate any advice and guidance regarding building such a
system.
 
I need to develop a multiuser database application to be used by four
people(The number of users are not likely to increase). It is for
storing records of different versions of particular papers. I am new
to

building such an application. I would like to know what would the
requirements be for using Access as the means for building the
multiuser database. Two of the four use Access 2000(running Windows
98)

and other two use Access 2003(running Windows 2000). Can any one
machine serve as server to host all queries from the users or do I
need

another machine to act as the server for the queries(if so please let
me know what OS should it use).

I would appreciate any advice and guidance regarding building such a
system.
Click to expand...

Access itself should not have a problem. You should split the database
so that the data is on the "server" and each user has their own front end
that holds the forms reports etc.

I suspect that you may have problems however. You did not say what kind
of network you are using, but I am going to guess that it is not a typical
high end professional network. Access does require a very robust network or
it may experience problems. That machine with Windows 98 is a good
indication of the problem.
 
Access is multi-user capable out of the box.

Split the application into the shared data store (one mdb containing just
the tables), and the application (another mdb containing all other
components, with linked tables.) If that is a new concept, see:
http://allenbrowne.com/ser-01.html

The data mdb can reside in any folder that is fully shared for all users
(read, write, and delete privileges). It can be one of the workstations, or
a dedicated server if you prefer.

Naturally you will use the Access 2000 file format so both versions can
understand it.

To ensure good performance, follow the suggestions in this article:
http://www.granite.ab.ca/access/performancefaq.htm
 
Back
Top