client/server setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Freed - 29 Oct 2009 21:10 GMT

I'd like to create a client/server application where multiple users can
read/write access a single table, each user accessing a unique portion of the
table. If I create a link to the table in each copy of the client database,
would there be a problem with multiple simultaneous users editing the table?
TIA....

Reply to this Message

Bernard Peek - 29 Oct 2009 21:19 GMT

>I'd like to create a client/server application where multiple users can
>read/write access a single table, each user accessing a unique portion of the
>table. If I create a link to the table in each copy of the client database,
>would there be a problem with multiple simultaneous users editing the table?
>TIA....

Are you sure that what you are looking for is a client/server system,
that's a specific technical term with limited applicability to Access.

However if you create a query on the server for each user and restrict
each query to one person's data, you can link each client to a different
query. This could get very complex if you have many users. It's possible
to simplify this by using some VBA code, provided you have sufficient
VBA skills.

Signature

Bernard Peek

Reply to this Message

John W. Vinson - 29 Oct 2009 21:42 GMT

There is a limit of 255 simultaneous users accessing a database. In practice,
things can get dicey if you have more than 30 or 40 users *SIMULTANEOUSLY
EDITING* (not just viewing) the database, and you will have problems if two
users try to simultaneously edit the same record.

How many "multi" users are you talking about?
Are they all on the same fast stable LAN, or are you talking about one user
from Tokyo and another from Poughkeepsie?

More info please!

Signature

John W. Vinson [MVP]

Reply to this Message