Database Sharing

[Guest]

Is it possible when replicating a database for more than one use to be in the
database at a time? If so, how many users can be in a database at once.

 

[Dirk Goldgar]

Is it possible when replicating a database for more than one use to
be in the database at a time? If so, how many users can be in a
database at once.

I'm not sure what you're asking. You can have multiple users in each
replica, if that's what you mean. If you're talking about actually
replicating an unreplicated database, I believe you need to have
exclusive access.

 

[Guest]

I'm asking if a replicated database can have multiple people using the same
replicated database at one time, ie. Can 7 people be inside the database at
once. If so, is there a limit to the number of people inside the database at
once. And if it's a regular database is it possible (without replicating) to
share a database like you would an Excel Spreadsheet?

 

[Rick Brandt]

I'm asking if a replicated database can have multiple people using
the same replicated database at one time, ie. Can 7 people be inside
the database at once.
Yes

If so, is there a limit to the number of
people inside the database at once.

The hard limit is 255. The practical limit varies depending on the design
of the app, what people are doing, and your LAN setup. 20 to 30 general
purpose users should be achievable and if most all were reading rather than
writing you could go much hgher than that.

And if it's a regular database
is it possible (without replicating) to share a database like you
would an Excel Spreadsheet?

Access is multi-user capable right out of the box. It is HIGHLY recommended
though that multi-user apps be split with each user having their own local
copy of the front end.

 

[Dirk Goldgar]

I'm asking if a replicated database can have multiple people using
the same replicated database at one time, ie. Can 7 people be inside
the database at once. If so, is there a limit to the number of
people inside the database at once. And if it's a regular database
is it possible (without replicating) to share a database like you
would an Excel Spreadsheet?

Replication and multiuser sharing are unrelated. See Rick Brandt's
excellent answer.