Results 1 to 2 of 2

Security Logon to database

  1. #1
    sdondeti is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Aug 2009
    Posts
    23

    Security Logon to database

    Hi All,

    I gave a security successfully in my local machine and able to logon by userid.
    Tools, Security, User And Group Accounts

    How should i give security for the database files on server? should i have to go on server and create users?

    Also On the server we don't have MS office s/w installed. How can is give security?

    Thanks for your help.
    SDondeti

  2. #2
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    134

    Security Logon to database

    When Microsoft Access is installed on your PC a default Workgroup Information File (System.mdw) is created. By default MS-Access uses this file to login Users (silently) while attempting to open a database. The default UserID is Admin and the Login Dialog Box will not appear until you set a Password for the Admin User. There are other Security issues if you continue to use this default Workgroup Information File.

    Create a separate Workgroup Information database (with .mdw extension) on a common location on the Server accessible to other Users of your Applications. You can do this by running the Wrkgadm.exe from the language folder (C:\Program Files\Microsoft Office\Office\1033). 1033 is US English folder, for MS-Office 2000. In MS-Access 2003 run this program from Tools - ->Security - ->Workgroup Administrator...

    Each User must run this program from their PCs and Join this common Workgroup Information database. You can implement Access Rights to each UsersGroup/User.

    Remember, this file contains only the UserId, PersonalID and passwords of Users and UserGroups. Permission settings are stored directly on the Database.

    Use the following link for more details: Microsoft Access Security

    PS: Don't forget to Read the Comment Section also.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Security question
    By maxx3 in forum Security
    Replies: 2
    Last Post: 01-14-2010, 03:27 PM
  2. Security..Is there another way?
    By marianne in forum Security
    Replies: 0
    Last Post: 07-19-2009, 06:18 PM
  3. Database Security
    By marianne in forum Security
    Replies: 4
    Last Post: 06-15-2009, 06:12 PM
  4. User Security
    By Sanrv1f in forum Security
    Replies: 1
    Last Post: 06-03-2009, 12:36 PM
  5. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 04:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums