Access to Access!!

[peekaboo_01]

We have one employee in our office that is having a most difficult time getting into any of the Access databases we use. Other people can log into the computer and have no problem - so it is not a desktop issue. I checked the database and there does not appear to be any "blocks" on the file. STILL she has been unable to open any of them. This is the error message she receives when trying to access Access:

Microsoft Access cannot open this file.

This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems.

To open the file, copy it to your maching or an accessible network location.


The reason this is a problem is: IT'S ALREADY ON AN ACCESSIBLE NETWORK LOCATION!!!

Has anyone run into this before? By the way this is Access 2002 (if it matters).

 

[KenHigg]

Sounds like this is more of a windows security issue than a ms access issue. I would suggest looking at the security settings on the other machines and mirror one of them...

 

[georgedwilkinson]

Compare her link to everybody else's.

Is she using a different Access version? If so, you might need to check her trust settings.

Does she run Vista? If so, well, I pity her. Vista does some nasty stuff to your security settings. Safest to turn off all (extra) Vista security unless your IT department has a policy.

 

[peekaboo_01]

Sounds like you nailed it!!! Now then, how do we get to the security settings? A quick glance did not easily locate the settings
? ? ? ?

 

[georgedwilkinson]

You didn't mention how I nailed it. I gave you 3 options.

Vista: Turn off User Account Control in the security center. After that, you might have to re-link your shortcuts.

Access 2007: On the Access Menu, select Advanced at the bottom right and go to Trust Settings.

Let us know back which thing fixed it. I'm very curious (and disturbed) by both Access 2007 and Vista messing around with stuff they shouldn't be messing around with.

 

[peekaboo_01]

Oh sorry, what I meant was the one thing that both the responders mention - changing the security setting. We do not have Vista (thank GOD!) And the current version of Access that we're using is 2002.

So, I'm trying to figure out just where the security settings are that we need to change. Is it in Access??

 

[boblarson]

Oh sorry, what I meant was the one thing that both the responders mention - changing the security setting. We do not have Vista (thank GOD!) And the current version of Access that we're using is 2002.

So, I'm trying to figure out just where the security settings are that we need to change. Is it in Access??

Tools > Macro > Security

 

[peekaboo_01]

Gosh that sounded so easy Bob!! Unfortunately...it did not work. We went right into Tools>Security and messed with several of those options to no avail. We compared her settings to ours and what we checked - was the same.

 

[boblarson]

Then Sandbox mode may have been enabled. See this MS KB article on how to enable/disable Sandbox mode:
http://support.microsoft.com/kb/239482

The disable part is about 2/3 of the way down the page.

 

[peekaboo_01]

<*blush*> I'm feeling a little stupid. This looks like we need to download a service pack? If not, does it mean that there is a place we can look at how "sandbox" is set?
I see where it tells you what the different settings are...so it's simply a matter of changing the setting from a 4 to a 1...but not sure how to get there????

 

[boblarson]

In the article, it tells you which registry key to look at:

\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode

 

[boblarson]

If you aren't sure how to find it in the registry, I would suggest getting IT help from your desktop admins. Mucking about in the registry can be dangerous unless you know what you are doing (and actually it can be even dangerous for someone who knows what they are doing )

 

[peekaboo_01]

Gotcha. Definately sounds like an IT thing. That way if they mess it up....it's THEIR fault!!! he he he

 

[apr pillai]

Perhaps re-installing the Office Programs may solve the problem. Just a passing thought.

 

[peekaboo_01]

You will all be amazed with the way we fixed this!! Believe it or not, it was adjusted through the Microsoft Explorer>Tools!!! For some reason Microsoft was not talking to the machine properly (???who knows, IT stuff right?). So just in case anyone runs across this....this is what we did:
In Microsoft Explorer, click Tools>Internet Option. Under the Security tab, select "Local Intranet". The click "Sites" under the top box. On the pop up box that comes up, click "Advanced". The top box asks "Add this website to the zone". In that box, we typed in the IP address of the computer. VOILA! That did it!!!!

Hope no one else ever runs into this problem. We pulled our hair out for weeks before we were finally able to get someone that knew how to fix this! Now YOU can look like the expert and fix it for them!!

Thank you sooooo much for all the help!