make Access Database available for five persons simultainously

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RebootKidFL - 25 Jul 2006 15:56 GMT

Hi

I'm creating a Database in Access I would like to know how can I make it
available for 5 or more people, in order for them to simultainously utilize
this database. Please my job depends on it.

Thanks

Reply to this Message

Allen Browne - 25 Jul 2006 16:18 GMT

Yes. Access is designed to be multi-user.

It would be a good idea to split the database.
If that's a new idea, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I'm creating a Database in Access I would like to know how can I make it
> available for 5 or more people, in order for them to simultainously
> utilize
> this database. Please my job depends on it.
>
> Thanks

Reply to this Message

RebootKidFL - 31 Jul 2006 17:11 GMT

Thanks Allen Browne.

> Yes. Access is designed to be multi-user.
>
[quoted text clipped - 10 lines]
> >
> > Thanks

Reply to this Message

John Vinson - 25 Jul 2006 16:57 GMT

>Hi
>
[quoted text clipped - 3 lines]
>
>Thanks

How about 255 people (the stated limit)? or more realistically, 30 to
50 people?

Access is multiuser out of the box. No special programming is
required.

In practice it's essential to "split" the database. See the
instructions at
http://home.bendbroadband.com/conradsystems/accessjunkie/splitting.html

John W. Vinson[MVP]

Reply to this Message

RebootKidFL - 31 Jul 2006 17:12 GMT

Thanks John Vinson.

> >Hi
> >
[quoted text clipped - 15 lines]
>
> John W. Vinson[MVP]

Reply to this Message