Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Access database admin

    Greetings,

    I am a wintel engineer that is responsible for maintaining our windows servers, hardware, OS, and backups.

    I recently had a ticket come in from a user that is requesting that she be given 'admin' access to a particular .mbd file that her department uses.

    It seems that the person that was the administrator of this database has left the company without turning over the admin login information to anyone.

    He is now unreachable, and his domain account has already been deleted.

    Are there any tools that I can run against this .mdb file that will allow me to change the internal password, so she can then take over maintaining the database?

    Thanks in advance.

    Jeff

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums.

    Is this a database that was developed by the IT department or by the guy who left? If it's by the IT dept, there should be some documentation somewhere with the password in it. If it was developed by the guy on company time, then you should check his contract to make sure if he's legally obligated to provide you guys with the password (that is to say that it's the company's IP).

    As far as I'm aware there's no downloadable software to change an Access mdb's internal password, but there could be someone else on this forum who may know of something.
    Me.Geek = True

  3. #3
    Join Date
    Apr 2009
    Location
    RI
    Posts
    31
    Is the mdb file password protected, or do you need to log into the application once the mdb file is opened? I know there's a program out there that can tell you what the password is on an mdb file (assuming it's the file that's locked).

  4. #4
    Join Date
    May 2009
    Posts
    2
    Thanks for the replys.

    This database was created and developed by the guy that is now gone.

    People can still log into the database, but no one has any admin privileges once inside.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If it's a username login situation, you would have an associated mdw file that holds all the usernames and passwords. That file can be read to reveal those password and usernames.

    BTW, if an employee creates a database on company time, the company owns copyright, not the employee, unless there is a specific contract stating otherwise. At least that is how it works here in Aus.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •