sharing database

  • Thread starter Thread starter Troy Scott
  • Start date Start date
T

Troy Scott

If I create a database on one machine and share it, say over network, can
two people make changes to the database at the same time?

thanks!

Troy
 
If you meant adding / modifying data then yes provided that the database is
opened in "Shared" mode.

OTOH for a multi-user database, you should (must, really) split the database
to Front-End and Back-End. The Back-End contain Tables only and resides on
a shared directory on the network. The Front-End contains all other Access
objects and each user should have a copy of the Front-End on his / her
desktop.

HTH
Van T. Dinh
MVP (Access)
 
Troy Scott mindspring.com> said:
If I create a database on one machine and share it, say over network,
can two people make changes to the database at the same time?
Click to expand...

Yes. It's better, though -- less susceptible to corruption in the event
of network glitches, and easier to do design work -- if you split the
database into a "back-end" database (containing tables only) on file on
the server, and a separate copy of the "front-end" database (containing
the forms, queries, reports, etc., with links to the tables in the
back-end) on each user's PC. See this page for more details:

http://www.granite.ab.ca/access/splitapp.htm
 
Back
Top