I want to develop a single database on a LAN for multiple
users, but haven't really seen any books that go into this
much depth. Even to the point of maybe even handling a few
concurrent users.

Anybody know of some websites or book titles that I might
take a look into?

Thanks

Hi,

Access has inherent multi-user support. Typically all you need do to
share a database across the LAN is:

1) split the database so the tables containing the data are in one "back
end" mdb file and everything else (queries, forms, reports, etc.) in
another. The built-in database splitter does this automatically,
creating linked tables in the "front end" as required.

2) install a copy of the front end on each workstation.

This works well for small numbers of users (the practical limit is
usually between dozens and a handful depending on the database, the
network and the kind of use it's getting).


On Fri, 16 Apr 2004 14:03:55 -0700, "Hi"
<(E-Mail Removed)> wrote:

>I want to develop a single database on a LAN for multiple
>users, but haven't really seen any books that go into this
>much depth. Even to the point of maybe even handling a few
>concurrent users.
>
>Anybody know of some websites or book titles that I might
>take a look into?
>
>Thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.