Results 1 to 10 of 10
  1. #1
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9

    Question How to Unprotect

    I just got hired and the first thing i am supposed to do is get a database set up for training record tracking. i am pretty good with access when i am setting up a database myself but the one that they are using was made by somone who wanted to make it very difficult to edit. i havent found a password that was set yet but everything is hidden and i cant create new reports or anything.



    do you guys have any ideas

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is it ac2007? Is there any difference when you open the db while holding down a <SHIFT> key?

  3. #3
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9
    no change when holding down <SHIFT> and yes it is access 2007 but it may have been created in 2003

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Does it have an AutoExec macro? Can you get to the Database window?

  5. #5
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9
    not sure about the autoexec, how would i check. and i think i am in the database window but i am not sure i have unhidden the navigation pane and can get access to the tables and everything but im not sure how to add report

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So you have the Nav Window open? Are there existing reports and can you see them? Can you see any Macros?

  7. #7
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9
    yes i have the nav window up and there is a section called modules is that what your talking about... there are three items in it

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is there a section called Reports? Is there a section called Macros?

  9. #9
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9
    there is a section called reports but no section called macros

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Based on your first post, I'm guessing you are not familiar with the totally revised interface of Access 2007. It sounds like you have everything available to make your changes and just need some time to get familiar with the new GUI.

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

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