Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Splitting Access Databases

Discussion in 'Information Technology' started by Daniel Nunn, Nov 9, 2005.

  1. Daniel Nunn

    Daniel Nunn
    Expand Collapse
    Guest

    Im using Microsoft Access 2002. I have created a database for my colleagues
    to store supplier information, however, at the moment it is only a single
    entity, and they cannot use it all at the same time. I know Access can split
    the database into a front and back end, but if I do this, will they then be
    able to add and modify records simultaneously?

    For instance, if they both want to create new suppliers in the database at
    the same time, will they be able to do this? Will they be able to see the
    records that each other are working on?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 8 Nov 2005 07:29:06 -0800, "Daniel Nunn" <Daniel
    Nunn@discussions.microsoft.com> wrote:

    >Im using Microsoft Access 2002. I have created a database for my colleagues
    >to store supplier information, however, at the moment it is only a single
    >entity, and they cannot use it all at the same time. I know Access can split
    >the database into a front and back end, but if I do this, will they then be
    >able to add and modify records simultaneously?
    >
    >For instance, if they both want to create new suppliers in the database at
    >the same time, will they be able to do this? Will they be able to see the
    >records that each other are working on?


    Yes.

    Access is multiuser, out of the box. So long as the users are not
    modifying exactly the same record in the same table at the same time,
    they should have no problem.

    John W. Vinson[MVP]
     

Share This Page