MS Access Multiuser - Multiuser access to a Access database with linked tables

Author

Multiuser access to a Access database with linked tables

blaairis

2005-09-19, 7:24 am

I have a Access database with linked tables in SQL-server. The database is
located on a windows2000 server. I use NT security with the SQL-server, so
the users don't need to log in to the database. If one user has opened the
Access database and another user tries to open the Access database nothing
happens. The database is set to shared access.
Tanks for help

Mary Chipman [MSFT]

2005-09-22, 8:25 pm

The optimal configuration where you have multiple users connecting to
the same SQL Server database through an Access linked table front-end
is to give each user their own copy of the mdb on their local machine.
Since you are using Windows authentication, each user then uses their
own credentials to connect.

--Mary

On Mon, 19 Sep 2005 04:09:02 -0700, "blaairis"
< blaairis@discussions
.microsoft.com> wrote:

>I have a Access database with linked tables in SQL-server. The database is
>located on a windows2000 server. I use NT security with the SQL-server, so
>the users don't need to log in to the database. If one user has opened the
>Access database and another user tries to open the Access database nothing
>happens. The database is set to shared access.
>Tanks for help

Sponsored Links