Splitting Access Databases

D

Daniel Nunn

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?
 
J

John Vinson

On Tue, 8 Nov 2005 07:29:06 -0800, "Daniel Nunn" <Daniel
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?
Click to expand...

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]
 
Top