Results 1 to 4 of 4
  1. #1
    bell is offline Advanced Beginner
    Windows 7 64bit Access 2002
    Join Date
    Feb 2015
    Posts
    37

    Exclamation How to get into Password Protected Database


    Hi all,

    I was given the task of updating my company's old database. The previous database was made by a employee who was terminated. The design of the database was awful, so I ended up redesigning the whole thing. Now, I need to try to import all the data from the previous database, so my company will not lose anything. Unfortunately, the back-end of the database is password protected. When I attempt to open it, I get the prompt "Password Required Enter database password:". Is there anyway to get around entering the password? We tried the terminated employees old computer password, but that wasn't it.

    I'm using Access 2002 if that helps.

    Thanks for the help.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,266
    check the Front end app. It may be embedded in the code.
    check the links too, hoover the cursor over the table, it may show there.

    or you can ask the employee for the password

  3. #3
    bell is offline Advanced Beginner
    Windows 7 64bit Access 2002
    Join Date
    Feb 2015
    Posts
    37
    Quote Originally Posted by ranman256 View Post
    check the Front end app. It may be embedded in the code.
    check the links too, hoover the cursor over the table, it may show there.

    or you can ask the employee for the password
    The guy was terminated from the job back in the early 2000s, pretty sure he won't answer any of our calls.

    And I cant view the code, when I open up Visual Basic from the front end and try to view code for a form, I get the popup "Project Locked Project is unviewable".

    Starting to feel like he made this impossible to screw with the company.

  4. #4
    Ajax is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,257
    Long time since I used 2002, the following refers to 2007 and later but the principle is the same

    in the front end can you see the navigation window? If so, view the system tables (if you can't see them go to File>Options>Current database>Navigation Options and tick show system objects) - also ensure 'Display Navigation Pane' is ticked

    Now open the MSysObjects table and look down the connect column where you will see something like 'MS Access;PWD=password;'

    If the password has been hardcoded and the front end is .mde then open the file in notepad to see all the code then search for 'P W D' - note the spaces

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

Similar Threads

  1. Password Protected Query Database
    By avicknair in forum Queries
    Replies: 9
    Last Post: 10-29-2015, 02:08 PM
  2. Replies: 3
    Last Post: 12-15-2014, 06:43 PM
  3. Replies: 2
    Last Post: 09-21-2012, 05:12 PM
  4. linking table in a password protected database
    By bdaniel in forum Programming
    Replies: 1
    Last Post: 01-04-2012, 01:25 AM
  5. Replies: 9
    Last Post: 12-02-2011, 08:52 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 - Senior Forums