Results 1 to 2 of 2
  1. #1
    teja is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    31

    accdb database logging in as Admin by default

    Hi all,

    I have created an .accdb database and attached it to WorkGrp.mdw work group file. I have added a new user "sa" and gave it all the permissions

    and removed all the permissions for Admin user. I also cleared the password for Admin user. Now when I try to open the .accdb file, it is not asking


    for password.

    Is there a way to make "sa" as default login???

  2. #2
    teja is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    31
    When you login into the database with "sa", next time it is used as the default login.

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

Similar Threads

  1. Logging Changes
    By nichmeg in forum Programming
    Replies: 0
    Last Post: 12-06-2011, 02:47 PM
  2. How to overcome a deadlock in Admin privilege
    By Babu1983 in forum Security
    Replies: 1
    Last Post: 09-02-2010, 12:09 PM
  3. Logging In
    By runtest in forum Programming
    Replies: 1
    Last Post: 02-21-2010, 11:55 PM
  4. Access Data Logging
    By pix in forum Access
    Replies: 0
    Last Post: 05-11-2009, 01:10 PM
  5. Admin Rights
    By Keri in forum Security
    Replies: 4
    Last Post: 11-18-2005, 11:18 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
  •  
Other Forums: Microsoft Office Forums