Results 1 to 8 of 8
  1. #1
    FFPantry is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    3

    Upgarded access now all forms broke


    Hi I'm helping a local cherity with their network. I came in this month in the middle of an upgrade form access 2003 to 2007 and in the newer version of access all the form buttons don't work. Now the front desk volinteers can't use the GUI. I've tried google and can't seem to find anything on this issue.
    Does anyone have any idea what's going on?
    I'm fairly tech savvy and have dabbled in SQL, but I've never had to deal with access and short of cracking an access textbook I'm not sure how to solve this.

    Thanks!

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    It seems like all code were disabled due to security issue by Access 2007.
    You need to enable the codes. there is a long bar below the menu(above the view windows) informing you of the code disabled. click and select enable it.

  3. #3
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    If the database is not in a trusted location, code will not run. Is any code running? Is there a bar under the ribbon that says "Security Warning..." with an option to enable content?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    FFPantry is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    3
    I'm not getting the security warning bar. Is there another menu where I can enable it?
    I don't think any code is running. The database is on a windows share form one computer, how should I make it a secure location?

  5. #5
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    That bar can be turned off, so it not being there isn't definitive. The trusted location is set at:

    Office Button/Access Options/Trust Center/Trust Center Settings/Trusted Locations
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I am not sure about other place to enable codes, I only have a few hours experience with Access 2007, I met your situation and enable the code by the bar.

    There are so many differences in 2007. I can't get comfortable with it in a short time, I won't continue using 2007 until I change my mind.

  7. #7
    FFPantry is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    3
    Thank you both! The message bar was disabled, and I was able to change the settings I needed in the trust center.

  8. #8
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    Excellent! Glad we got you going. Welcome to the site by the way.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. I just gone broke it
    By onechriswhite in forum Access
    Replies: 2
    Last Post: 08-23-2010, 05:06 PM
  2. Need Help with forms on MS Access
    By orion in forum Forms
    Replies: 4
    Last Post: 06-23-2009, 08:08 PM
  3. Controlled access to forms
    By Rameez in forum Forms
    Replies: 6
    Last Post: 06-18-2009, 02:18 AM
  4. Help with Access & Forms
    By gnatgnats in forum Forms
    Replies: 2
    Last Post: 02-18-2008, 10:33 AM
  5. Replies: 0
    Last Post: 01-19-2007, 07:58 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