Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    More aggravation (Access 2007)

    So, I discovered today that Access2007 sets Sandbox Mode to On by Default!

    I kept getting an #Error message for a text control on a report. The controlsource of the report looked-up the Caption of a tabcontrol page on a form. When I took the expression and ran it from the immediate window, I got a pop-up error that said something to the effect that "pages was an unsafe expression that was blocked by sandbox mode"!

    Give me a break! What other unsafe expressions will they block next? Perhaps Backcolor?

    So, I set sandbox mode off and didn't get the error anymore. You need to use regedit, and select HKEY_LOCAL_MACHINE, then navigate to this key:

    SoftwareMicrosoftOffice12.0Access Connecivity EngineEngines

    Once you click on "Engines", you should see SandboxMode in right pane. Double-click it and change the value from 3 to 2.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More aggravation (Access 2007)

    I can see why I

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    I don't know of any way, other than to start a specific thread with subject something like: "Access2007 is a Pain", or something like that! Then we can add to it as we find more bugs/quirks. This should work, depending on how much disk space our host has! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More aggravation (Access 2007)

    Out of curiosity, have you found out how I can display descriptions stored in the properties of the icons within a database? I'm talking about the descriptions you can add to a form or a query saying:"Feeds query x".

    I have a database I maintain where they have upgraded to 2007 and I find it very frustrating with the new navigation pane (pain) that I can't see any of those descriptions. Many of the reports depend on multiple queries and my descriptions helped me keep track of what did what to whom. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: More aggravation (Access 2007)

    <P ID="edit" class=small>(Edited by charlotte on 14-Apr-07 20:54. Corrected instructions )</P>Right click in the navigation group header for the queries and select View by --> Detail. That will show the description, as well as the dates created and modified.
    Charlotte

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: More aggravation (Access 2007)

    The simple way around it is to add the folder that contains your database to the Trust Center. Click on the round Office button in the upper left and select the Access Options button at the bottom right. In the dialog that comes up, select the Trust Center, click the Trust Center Settings button, and select Trusted Locations. On the resulting dialog, you can add any folders or locations you want. That same option is available from the other Office 2007 apps as well. That's the reason Sandbox is on by default, because you have the ability to selectively turn it off for specific locations.
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    Thanks Charlotte. I remember seeing a vague reference to Trusted Locations, but I didn't know how they were declared. As usual, Help just assumes you know everything about this subject, and just need a reminder of what to do.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    Charlotte,

    I've been giving this some more thought. I assume you can't set the Trusted Locations via code (this would kind of subvert the intent). However, can you read the locations through code? If so, we could determine whether the location of the db was in a trusted location, and if not, then pop a box with instructions on how to do it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: More aggravation (Access 2007)

    I can't answer that definitively, Mark. I'm just getting my feet wet in 2007 myself. Offhand, I think I would just attempt a connection and trap the error if any.
    Charlotte

  10. #10
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    >> can't answer that definitively, Mark. I'm just getting my feet wet in 2007 myself. <<

    Same here. I don't even have a Vista machine with Office2007 on it, I've been borrowing one periodically from a company I do contract work for, as we work around some of the Access2007 bugs/quirks we've found.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: More aggravation (Access 2007)

    I installed Office 2007 on my XP Pro laptop. I can't handle a new version of Office and a new OS at the same time!! <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Charlotte

  12. #12
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    Quite frankly, I'm not real enthusiastic about either one! Access2007 is fast becoming a real pain.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: More aggravation (Access 2007)

    Well I wish we hadn't. We have a client who upgraded all their workstations to Vista and Office 2007 at the same time. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
    Actually, considering all the possible things that could go wrong, it has gone fairly smoothly. HOWEVER - we appear to have a bit of a nasty problem when using Access 2007 on a Vista PC. We have an application where if you right-click on a subform, Access crashes - however Access 2007 works just fine if you are running the application on an XP system. And Access 2003 works just fine on either XP or Vista. We also appear to be missing double-click events on a control in a subform - works fine on XP but not on Vista. Has anyone else seen strange behavior when right-clicking or double-clicking?
    Wendell

  14. #14
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: More aggravation (Access 2007)

    The only right-click issue we've notice so far is that Access2007 won't recognize the specified menu when you right-click in a subform. It will display some default menu.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  15. #15
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: More aggravation (Access 2007)

    We hadn't gotten that far - it always crashed before we could read the menu. But I see MS released a hot-fix last Friday - see <!mskb=935875>Microsoft Knowledge Base Article 935875<!/mskb>. No mention of whether it occurs only on Vista, or is independent of the OS.
    Wendell

Page 1 of 2 12 LastLast

Posting Permissions

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