Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31

    How do i remove access 2010 security

    Hi guys i have a Access 2003 database converted to access 2010, and some time ago i set a password or user security, and no i would like to remove it but no matter what i do i am unable to remove this security



    Can some one help me please

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by sam49 View Post
    Hi guys i have a Access 2003 database converted to access 2010, and some time ago i set a password or user security, and no i would like to remove it but no matter what i do i am unable to remove this security

    Can some one help me please
    We really need to know if it is a database password or user level security.

    If you converted the MDB to a ACCDB then is is probably a database
    password.

  3. #3
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Hi i am not sure what the security is. when it loads it asks me for the password and then works fine it just will not let me remove the password.
    If i open it in the exclusive mode i put in the password and the i get to option to set a password.
    But whatever i enter it say not a valid password if i try and set a new one.

    So does this mean it might be user level security

    I enter data into this database on a daily basis and i have some old backups and it will let me remove the password from them ok if i use my computer running acccess 2007 but not the latest version.

    Regards to you all

    Hope you can help

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Does it open the same if you hold down a <SHIFT> key? Do you have an AutoExec Macro?

  5. #5
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Hi yes it does still open if i hold down a Shift key

    And i have no Macro's running at all not that i know about.

    And if i open the database and go to File then Info it says it is a .acdb file.

    Then the only option on the right is to create a password not remove it, if i try and add a password it say invalid password.

    As i have said above i have an old backup and it lets me remove the password ok but i have lost all the latest data i have input.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Does it still ask for a password when you open it while holding down a <SHIFT> key?

  7. #7
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    I am not sure what you mean by <SHIFT> is it just the normal shift keys

    I have tried both the normal shift keys and yes it does still ask for the password.

    Regards

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    No! Either shift key will bypass the startup if it has not been disabled.

  9. #9
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Ok well it does still ask for the password with the shift key held down.
    I think the database file must be faulty as it works fine just will not let me remove or change the password

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is there a Startup Form? Do you have a Macro named AutoExec? Can you see the Database window after you open the db? Is there anything else besides changing the password that you *cannot* do?

  11. #11
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Hi not sure what you mean about a startup form ans as far as i know there are no marcro running at all.
    Not sure what you mean about the database window, and no all i want to do is remove the password
    Regards

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can you see all of the tables and forms, etc. Can you open them in design mode?

  13. #13
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Yes i can see them and open and change all the forms, tables, reports it works fine with everything just will not let me remove the password.

  14. #14
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried importing the db into a fresh db and see if the security follows?

  15. #15
    sam49 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    31
    Yes i have tried on my laptop with a new instalation of access

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. 2003 Security in 2010
    By tgavin in forum Security
    Replies: 0
    Last Post: 07-29-2010, 10:00 AM
  2. Replies: 5
    Last Post: 06-23-2010, 01:41 PM
  3. Access security problem
    By ShadowFox in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:23 PM
  4. Access security issues
    By Zeallord in forum Security
    Replies: 2
    Last Post: 04-17-2009, 05:11 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