+ Post New Thread
Results 1 to 6 of 6
Windows Thread, MS access 2003 security problem in Technical; One of our pupils has forgotten the admin password for his secured access 2003 .MDB. Does anyone know of a ...
  1. #1

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15

    MS access 2003 security problem

    One of our pupils has forgotten the admin password for his secured access 2003 .MDB. Does anyone know of a simple way to "break in" or what the default password is? We've tried downloading one type of password recovery program, but the download failed.

  2. #2
    bizzel's Avatar
    Join Date
    Jul 2007
    Location
    Cambridge
    Posts
    654
    Thank Post
    102
    Thanked 204 Times in 72 Posts
    Rep Power
    51
    I have in the past used Access Key and that's worked well. It also supports Access 2007, which is nice. It's not free but the demo version will show the first two letters of the password - that might be enough to jog your student's memory. I'd also look at running it on either an unused workstation or a beefy server overnight since if you enable options like symbols, capitals, etc (and you should) it'll take some time.

  3. #3

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15
    Thanks for the speedy reply, the problem is that he's apparently used the "user level security" system in access 2003 and it's gone wrong.

  4. #4

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,763
    Thank Post
    3,273
    Thanked 1,053 Times in 974 Posts
    Rep Power
    365
    just so I am clear on how he/she set the security and or password on this database can you give me a basic step by step on what he/she did originally to set the password.

    Thanks

  5. #5

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15
    I think they ran the database user level security wizard and created their own user for their database, now it seems that that user does not have full access rights for the DB, and the user can't access their tables. The ownership of these come up as "unknown" when we try and change ownership to allow access.

    I'm at the moment trying to recover a backup so that the student doesn't loose too much work, but it's getting rather fraught

  6. #6

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15
    Problem fixed!

    Turns out there was an issue with the workgroup file (the user had about 4), process of elimination lead us to the right one, and we then extracted the work from the MDB.

    6th former informed of the concept of "back up before applying security"....

SHARE:
+ Post New Thread

Similar Threads

  1. Word 2003 Security SUCKS!!
    By markwilliamson2001 in forum Windows
    Replies: 20
    Last Post: 3rd November 2009, 01:29 PM
  2. Vista & MS Access 2003 Problem
    By ICTNUT in forum Windows Vista
    Replies: 6
    Last Post: 15th June 2007, 03:10 PM
  3. Redirected My Documents security problem
    By netadmin in forum Windows
    Replies: 3
    Last Post: 22nd May 2007, 09:14 PM
  4. Security Groups in 2003
    By SpuffMonkey in forum Windows
    Replies: 1
    Last Post: 19th July 2006, 11:18 PM
  5. Exchange 2003 web access problem
    By Rozzer in forum Windows
    Replies: 3
    Last Post: 18th January 2006, 10:09 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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