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.

(E-Mail Removed) wrote:
> 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.

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.


--
Joseph Meehan

Dia duit

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.