Simultaneous access to .mdb file

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I know that it is not possible to open and edit the
same .mdb file from different computers on a network
simultaneously.
But sometimes it is neccessary for different users to
access and edit data simultaneously in order not to waste
time waiting for each other to close the file.
What are the ways to make it possible? If there are many,
what is the easiest way?
Thank you in advance.
Mike
 
See comments in-line.

--
HTH
Van T. Dinh
MVP (Access)



Mike said:
I know that it is not possible to open and edit the
same .mdb file from different computers on a network
simultaneously.
Click to expand...

If by edit, you meant editing data, then you can open the same database from
different computers simultaneously if the users open the database in
"shared" mode. There may be some conflicts if 2 or more users trying to
edit the same Records at the same time (see Access Help on Record-locking)
See further down.


But sometimes it is neccessary for different users to
access and edit data simultaneously in order not to waste
time waiting for each other to close the file.
What are the ways to make it possible? If there are many,
what is the easiest way?
Click to expand...

The best way is to split your database to Front-End and Back-End (see access
Help on splitting a database). The Back-End contain only Tables which
resides on a network share. The Front-End contains all other Access object
and each user should have a copy of the Front-End on his/her desktop.
 
Mike said:
I know that it is not possible to open and edit the
same .mdb file from different computers on a network
simultaneously.
But sometimes it is neccessary for different users to
access and edit data simultaneously in order not to waste
time waiting for each other to close the file.
What are the ways to make it possible? If there are many,
what is the easiest way?
Thank you in advance.
Mike
Click to expand...

Actually you can edit the same file, just not the same record(s).

Split the database into a front-end, containing all the forms, queries,
reports, and code, which will run on each workstation and a back-end,
containing the data tables, which will run on the server. Link the tables to
the front-end and away you go. <g>

Hint: there's a wizard to help you. From the menu, choose Tools ... Database
Utilities ... Database Splitter
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top