Access Database as Multifulser

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am having a database and i had make another database linking the table from
main database but i am not able to update the data at a same time in main
database and link database.

i want to use this database as a multiuser database so two person can make
entry/ update the data at a same time.
 
Make sure that the database is split into the tables (data) and application.
Put the backend (tables) on a server and link a copy of the front-end
(application) to it from each of the computers. Make sure that you don't
lock the entire table when updating or the second user may not be able to
add/edit records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
There is a utility in Access to split your database into a front-end and
back-end. You will want to keep the back-end on a shared network drive, and
a copy of the front-end will need to be placed on each computer that will
need to access it. To find the database splitter, goto Tools - Database
Utilities - DAtabase splitter. Before doing this make a back up copy of the
original in case something goes wrong.

This will allow more than 1 person to user the database at a time.

Hope this helps
 
Back
Top