Multiple Users on an 2003 Access Database

microsoft.public.access.security

20 Sep 2006 9:39 AM

AlanK

I have set up an Access 2003 Database.
Multiple Users will have to be able to work on this database at the same time.
(i.e. two users can create a query on the one table at the same time).

I have done the above in the past on existing databases however I have never
set
one up from scratch.

I would appreciate any assistance.

Thanks,

Alan.

20 Sep 2006 12:07 PM

Joan Wild

The usual method is to split your mdb. Put the backend (just the tables) on
a server, and give each user a copy of the frontend (all other objects) mdb
which would have linked tables to the backend.

--
Joan Wild
Microsoft Access MVP

AlanK wrote:

Show quoteHide quote

> I have set up an Access 2003 Database.
> Multiple Users will have to be able to work on this database at the
> same time. (i.e. two users can create a query on the one table at the
> same time).
>
> I have done the above in the past on existing databases however I
> have never set
> one up from scratch.
>
> I would appreciate any assistance.
>
> Thanks,
>
> Alan.