RE: Annoying MS Access Error
Did this start to happen after SP3 was installed? I know i have seen similar issues post an SP3 install. From: Tom Miller [mailto:tmil...@hnncsb.org] Sent: 07 May 2009 16:31 To: NT System Admin Issues Subject: Annoying MS Access Error Hi Folks, MS Access Office XP on Windows XP SP3. Some users are now reporting the get an access denied error when attempting to open an access database on one of our shared folders (Netware drive, actually). I can't tell but I think one of the recent MS patches may have caused it. Here's the error: ** Microsoft Access cannot open this file. The file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. If the user copies the file to his/her desktop, it opens fine. I've seen this before, but none of the suggestions via Google really fix the problem. Thinking it's related to IE, I reset the settings, but that has not changed. I don't have the error, and I think it's profile related (I can log onto the user's destop and open the file), but I hate to blow away a profile Suggestions? Tom Miller Engineer, Information Technology Hampton-Newport News Community Services Board 757-788-0528 Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. The information contained in this E-Mail and any subsequent correspondence is private and is intended solely for the intended recipient(s). The information in this communication may be confidential and/or legally privileged. Nothing in this e-mail is intended to conclude a contract on behalf of QinetiQ or make QinetiQ subject to any other legally binding commitments, unless the e-mail contains an express statement to the contrary or incorporates a formal Purchase Order. For those other than the recipient any disclosure, copying, distribution, or any action taken or omitted to be taken in reliance on such information is prohibited and may be unlawful. Emails and other electronic communication with QinetiQ may be monitored and recorded for business purposes including security, audit and archival purposes. Any response to this email indicates consent to this. Telephone calls to QinetiQ may be monitored or recorded for quality control, security and other business purposes. QinetiQ Limited Registered in England Wales: Company Number:3796233 Registered office: 85 Buckingham Gate, London SW1E 6PD, United Kingdom Trading address: Cody Technology Park, Cody Building, Ively Road, Farnborough, Hampshire, GU14 0LX, United Kingdom http://www.qinetiq.com/home/notices/legal.html ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
Re: Annoying MS Access Error
On 7 May 2009 at 11:30, Tom Miller wrote: Hi Folks, MS Access Office XP on Windows XP SP3. Some users are now reporting the get an access denied error when attempting to open an access database on one of our shared folders (Netware drive, actually). I can't tell but I think one of the recent MS patches may have caused it. Here's the error: ** Microsoft Access cannot open this file. The file is located outside your intranet or on an untrusted site.Microsoft Access will not open the file due to potential security problems. If the user copies the file to his/her desktop, it opens fine. I've seen this before, but none of the suggestions via Google really fix the problem. Thinking it's related to IE, I reset the settings, but that has not changed. I don't have the error, and I think it's profile related (I can log onto the user's destop and open the file), but I hate to blow away a profile Suggestions? I doubt if this will help, but MS Access on Novell file servers has long had problems related to the number of file handles that Access attempts to open. Google oplocks (or opportunistic locks) and access and novell or netware for more than you ever wanted to know ;-) Microsoft Access Performance FAQ http://www.granite.ab.ca/access/performancefaq.htm Corrupt Microsoft Access MDB Causes - Oplocks http://www.granite.ab.ca/access/corruption/causesoplocks.htm -- Angus Scott-Fleming GeoApps, Tucson, Arizona 1-520-290-5038 +---+ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
RE: Annoying MS Access Error
Caveat: I have Access 2007, so the options are likely to be a bit different. Have you tried going into the trusted locations and adding that netware drive as a trusted location? I've had to do that on some of my clients for databases that are on a Windows Server 2003 share. John-AldrichTile-Tools From: Tom Miller [mailto:tmil...@hnncsb.org] Sent: Thursday, May 07, 2009 11:31 AM To: NT System Admin Issues Subject: Annoying MS Access Error Hi Folks, MS Access Office XP on Windows XP SP3. Some users are now reporting the get an access denied error when attempting to open an access database on one of our shared folders (Netware drive, actually). I can't tell but I think one of the recent MS patches may have caused it. Here's the error: ** Microsoft Access cannot open this file. The file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. If the user copies the file to his/her desktop, it opens fine. I've seen this before, but none of the suggestions via Google really fix the problem. Thinking it's related to IE, I reset the settings, but that has not changed. I don't have the error, and I think it's profile related (I can log onto the user's destop and open the file), but I hate to blow away a profile Suggestions? Tom Miller Engineer, Information Technology Hampton-Newport News Community Services Board 757-788-0528 Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.323 / Virus Database: 270.12.21/2102 - Release Date: 05/07/09 05:57:00 ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~image001.jpgimage002.jpg
Re: Annoying MS Access Error
I've had the same issue with VBScripts running across network shares. Had to start running them locally. Agreed I do believe it's an IE security setting, but haven't researched it enough to actually remove the issue. On Thu, May 7, 2009 at 8:30 AM, Tom Miller tmil...@hnncsb.org wrote: Hi Folks, MS Access Office XP on Windows XP SP3. Some users are now reporting the get an access denied error when attempting to open an access database on one of our shared folders (Netware drive, actually). I can't tell but I think one of the recent MS patches may have caused it. Here's the error: ** Microsoft Access cannot open this file. The file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. If the user copies the file to his/her desktop, it opens fine. I've seen this before, but none of the suggestions via Google really fix the problem. Thinking it's related to IE, I reset the settings, but that has not changed. I don't have the error, and I think it's profile related (I can log onto the user's destop and open the file), but I hate to blow away a profile Suggestions? Tom Miller Engineer, Information Technology Hampton-Newport News Community Services Board 757-788-0528 Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
RE: Annoying MS Access Error
We have run into the same problem - I don't think it is related to any of the recent patches. You can add the server name to the trusted sites in IE or you can add the extension to the Inclusion list for low file types. We haven't been successful with the low file type method adding more than 1 extension so we are working on the trusted sites route now. The only time we see it is if another user already has the database already open. -Brian From: Eric Woodford [mailto:ericwoodf...@gmail.com] Sent: Thursday, May 07, 2009 10:59 AM To: NT System Admin Issues Subject: Re: Annoying MS Access Error I've had the same issue with VBScripts running across network shares. Had to start running them locally. Agreed I do believe it's an IE security setting, but haven't researched it enough to actually remove the issue. On Thu, May 7, 2009 at 8:30 AM, Tom Miller tmil...@hnncsb.org wrote: Hi Folks, MS Access Office XP on Windows XP SP3. Some users are now reporting the get an access denied error when attempting to open an access database on one of our shared folders (Netware drive, actually). I can't tell but I think one of the recent MS patches may have caused it. Here's the error: ** Microsoft Access cannot open this file. The file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. If the user copies the file to his/her desktop, it opens fine. I've seen this before, but none of the suggestions via Google really fix the problem. Thinking it's related to IE, I reset the settings, but that has not changed. I don't have the error, and I think it's profile related (I can log onto the user's destop and open the file), but I hate to blow away a profile Suggestions? Tom Miller Engineer, Information Technology Hampton-Newport News Community Services Board 757-788-0528 Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
RE: Annoying MS Access Error
I tried that but it does not work. Very annoying. Also, EVERY reply to this list gets rejected. What a PITA. Caveat: I have Access 2007, so the options are likely to be a bit different. Have you tried going into the “trusted locations” and adding that netware drive as a trusted location? I’ve had to do that on some of my clients for databases that are on a Windows Server 2003 share. Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: Annoying MS Access Error
It could be macro security in MS Access. We use run time access 2007 and had to issue a reg hack for some of our db's. With full blown access 2007 you can do this in via Access general options. You do have to check allow network bla bla bla Just a shot - we had this from day one of deploying office 2007. -Devin On Thu, May 7, 2009 at 11:13 AM, Tom Miller tmil...@hnncsb.org wrote: I tried that but it does not work. Very annoying. Also, EVERY reply to this list gets rejected. What a PITA. Caveat: I have Access 2007, so the options are likely to be a bit different. Have you tried going into the “trusted locations” and adding that netware drive as a trusted location? I’ve had to do that on some of my clients for databases that are on a Windows Server 2003 share. Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- Devin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
