Any resources covering developing multi-user Applications?

  • Thread starter Thread starter Hi
  • Start date Start date
H

Hi

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).
 
Back
Top