Access Login

From: Pool (Pool_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 13:39:09 -0700

Hi,
am converting access 97 to 2003 and have like 10 databases. i want to create
username and pwd for each person in the office so that they have different
permissions.

Q1. Can i have the same username and pwd for all for different databases
provided they have same permissions.
Q2. Can i associate the windows log in with the database security. I mean,
permissions should be decided based on there windows NT login.

Thanks in advance.

Relevant Pages

  • Re: Access 2000 LOGIN
    ... > user for all the databases in the network so that they can ... > access all the databases on the network with same username ... The permissions are stored in the mdb file. ... workgroup file and have all your databases use it to authenticate users. ...
    (microsoft.public.access.security)
  • RE: missing system.mdw file
    ... permissions to create the file, ... >The registry key is not missing. ... Running the SCAN program from the Windows ... >>| I cannot create any new databases in Access 2002 on ...
    (microsoft.public.access.setupconfig)
  • Re: one SQL DB getting info from another - user setup?
    ... It appears from your narrative that the Main and DB1 databases ... EXEC sp_helpdb 'Main' ... SQL 2000 SP3 and is turned off by default. ... > In the permissions for Main, USER1 and USER2 are listed, but have NO ...
    (microsoft.public.sqlserver.security)
  • Re: MDB remembers old MDW
    ... The workgroup file is used for a session of Access - any number of databases ... The mdw defines the usernames/passwords and group memberships. ... permissions are stored in the mdb file with the objects. ...
    (microsoft.public.access.security)
  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)