Just for information,
Adam99 can't see your answer at present. Even when Excelforum fixes their
feed, I don't know if these missed postings will be propagated. Good
information none-the-less.

--
Regards,
Tom Ogilvy


"Jamie Collins" wrote in message
om...
I think accepted wisdom states the safe limit to the number of users
*connected* to a Jet database at any one time is approximately eight
users i.e. much lower than advertized. You can support more
*concurrent* users by implementing a 'disconnected' model e.g.
disconnected recordsets with client side cursors and either
batch-optimistic locking or updating via direct execution of SQL in a
transaction etc. In other words, users may have local copies of the
data, possibly with locks on that data to prevent other users from
changing it, but only actually connect to the database briefly to
fetch and update data. Whether this connection strategy is an
acceptable risk is discussed in this thread:


http://groups.google.com/groups?selm...GP11.phx.gb l

I too recommend the MSDE route.

Jamie.

--