Sending users to sql server

From: Roy Goldhammer (roygoldh_at_hotmail.com)
Date: 01/10/05


Date: Mon, 10 Jan 2005 13:13:18 +0200

Hello there

I have an old application designed in accesss

they transfare the database to sql server and use it as SA.

Now i would like to transfare the access users on the workgroup to sql
server so that any user will have its own User on sql server

Is there a short way to do this instead of building each user on sql server?
and is there a way afterthat to change it on access?



Relevant Pages

  • Locking out MS Access Users...
    ... I have an ASP.NET web application that uses a SQL Server 2000 database. ... audit activity at the database level. ... How can I prevent MS Access users from ...
    (microsoft.public.sqlserver.security)
  • Insert Into Problem
    ... I have two tables on sql server with the same key ... I need to transfare these ... FROM Table1 LEFT JOIN Table2 ON ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)