Results 1 to 5 of 5

Thread: Password in Access 2007

  1. #1
    Join Date
    Dec 2008
    Posts
    17

    Password in Access 2007

    Hello,

    I was working with access 2003 and have now installed Access 2007. In my files, I have passwords. How do I remove these passwords in Access 2007 and also when opened and / or how do you create passwords as soon as they open? Among other things, how do you view the tables, queries, forms, etc. ... or it is like that they are already created? Thank in advance

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Password in Access 2007

    Hello , Can You see the Encryption option? It might be there. and also You set and remove a database password in Microsoft Office Access 2007 by using the Set Database Password and Unset Database Password dialog boxes. These dialog boxes appear when you click the Encrypt with Password command and the Remove Database Password And Encryption command , respectively, in the Database Tools group on the Database Tools tab. Are you sure that they used Access' password protection and not some homebrewed password? Try opening the database while holding down the F11 key. If you aren't prompted for a password, it was homebrewed. If the F11 key is disabled, check out the code behind the opening form

  3. #3
    Join Date
    Apr 2008
    Posts
    4,088

    Re: Password in Access 2007

    When you remove a password from a database, you can restore it at any time (or replace it with another password) by repeating the steps in Encrypt a database by using a password,

    1. Remove a password
    2. Open the database in Exclusive mode.
    3. On the Database Tools tab, in the Database Tools group, click Decrypt Database.
    4. The Unset Database Password dialog box appears.
    5. Type your password in the Password box, and then click OK.

  4. #4
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Password in Access 2007

    1. To open a table in design view, right-click on the table name in the left window and selecting Design View from the popup menu.
    2. The window on the right should now display the table information.


    For More Information check this link http://office.microsoft.com/en-us/ac...646911033.aspx

  5. #5
    Join Date
    Jul 2011
    Posts
    1

    Re: Password in Access 2007

    my friend set a password to access2007 which we are using...now i wanted to remove thepassword using the database tools...my problem is "encrypt with password" is showing instead of "decrypt". how did it happen? i tried to encrypt it again using the password we are using but error is "Invalid Password"... kindly help me

Similar Threads

  1. Replies: 3
    Last Post: 11-12-2010, 11:45 PM
  2. exchange 2007 outlook 2007 keeps asking password
    By Breckon in forum Small Business Server
    Replies: 2
    Last Post: 07-07-2010, 12:44 PM
  3. Read Access 2003 files with Access 2007
    By Kendal-J in forum Windows Software
    Replies: 2
    Last Post: 26-05-2010, 05:57 PM
  4. Retrieve data from Access 2007 to Excel 2007
    By Markesh in forum Windows Software
    Replies: 3
    Last Post: 23-09-2009, 08:20 AM
  5. How to Automatically access the fields of an Access 2007 forms
    By Corona in forum Software Development
    Replies: 3
    Last Post: 25-06-2009, 12:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,867,107.12733 seconds with 17 queries