Multiple Users Enviroment

Thanks guys. I will try the way you guys said.

"John Vinson" wrote:

On Wed, 19 Oct 2005 08:00:04 -0700, "AccessHelp"
wrote:

If I just have a copy of database in a shared drive, only one
user will be able to use it.

That statement is *simply incorrect*. Access is a multiuser database
environment, out of the box.

"Splitting" is a good idea - it means that you should have one
database file containing the Tables, on a shared drive; each user
should have their own copy of the "frontend" containing the forms,
reports, etc. with links to the tables in the backend.

Database Replication is complex and rather hard to manage, and is not
appropriate for this situation. It's needed when you have users who
are not sharing a network (say one user at the office and another
traveller using the database on a laptop); it lets you keep two
backends (containing, again, just the tables) synchronized. If all
your users have access to the shared backend over a reasonably fast,
stable LAN then replication is just a lot of extra work for no
benefit.

See http://www.granite.ab.ca/access/splitapp/index.htm for a thorough
overview of the database splitting issue.

John W. Vinson[MVP]