More aggravation (Access 2007)

Topic

New Reply

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.

Reply | Quote

Replies

I can see why I

Reply | Quote

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!

Reply | Quote

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.

Reply | Quote

(Edited by charlotte on 14-Apr-07 20:54. Corrected instructions )

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

>> 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.

Reply | Quote

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!!

Reply | Quote

Quite frankly, I’m not real enthusiastic about either one! Access2007 is fast becoming a real pain.

Reply | Quote

Well I wish we hadn’t. We have a client who upgraded all their workstations to Vista and Office 2007 at the same time.
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?

Reply | Quote

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.

Reply | Quote

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 Microsoft Knowledge Base Article 935875. No mention of whether it occurs only on Vista, or is independent of the OS.

Reply | Quote

Thanks!

Does anyone know if “hot fixes” are part of normal Office updates, or do you have to download them separately? And is there a list of Hot Fixes somewhere?

Reply | Quote

A hot fix may eventually find its way into a regular update or service pack, but they are not part of the normal Office updates. The MSKB article for a typical hot fix usually contains this text:[indent]

---

A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next 2007 Microsoft Office service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. …

---

[/indent]

Reply | Quote