Multiple user viewing and amending

[Guest]

If a database is to be used by the whole company, can multiple-users view the
database, make amendments (in Access or linked contact databases), run
queries etc at the same time??

 

[Rick B]

Yes.

In general, you should have a back-end database stored on a server with all
the tables in it. You should have separate front-end databases on each
user's PC that links to the back-end . The front ends should contain the
queries, reports, and forms, along with links to the backend tables.

Do some searches on "splitting your database" if you have more questions
about the front-end/back-end principle.

 

[Albert D.Kallal]

Yes, you can have multiple users working on the data at the same time.

.. To do this properly, you need to split your database. You then place the
application part on each pc, and then can share the back end mdb file.

You can read about this here:

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