Replication is primarily for people who need to work _dis_connected from the
network. Access provides, out of the box, "multiuser" capability, which is
what you describe. There is a Microsoft-sponsored newsgroup at the free news
server "news.microsoft.net", called "microsoft.public.access.multiuser"
dedicated to this subject.
You'll also find a Power Point presentation on Access in a multiuser
environment, a general overview, at
http://appdevissues.tripod.com.
The very best collection of information and links about Access performance
and corruption avoidance in a multiuser environment that I have found is at
MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm. Another good
site is MVP Jeff Conrad's
http://home.bendbroadband.com/conrad...essjunkie.html, with a
significant amount of Access information on a wide range of topics.
In the simplest case, you put your database in a shared folder accessible to
all the users (make sure each has read, write, create, and delete
permissions on that folder) and have each user open the database in "shared
mode".
Larry Linson
Microsoft Access MVP
"jodyblau" <jo******@gmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
I'm fairly new to access, so I hope this question isn't too elementary.
I'm putting together a database for my office. I want the database to
be accessible to 5 or 6 users on our network and so itt may be used by
more than one person at the same time.
I am hoping that someone can give me an idea of some of my options in
facilitating this. My instinct, from fishing around in the database
options, is that it might have something to do with replicating and
synchronizing the database.
Are there different ways of approaching this? What are they? Pro's &
Con's ?
Thank you,
Jody Blau