|
|
||||||
|
#1
02-27-08, 05:04 PM
|
|
|
|
|
This problem got around 2500 hits in Google and one hit in this discussion
group. None of the posted solutions solved it for me: ------------------ Computer A on a LAN has an mdb with tables in it. Computer B runs Access. Both computers use Office 2002 running on Windows XP. When I try to link the program on Computer B to the files on A, Computer B can see the mdb on the shared folder in A, but when I try to open it for linking, I get the message "Access cannot open this file. This file is located outside your intranet or on an untrusted site." On Computer B, I can run Word 2002 and open any doc file in the shared folder on A, edit and change it, and save it. Windows explorer lets me do anything I want in A's folder, including delete, rename, copy, etc. I don't know if this matters: the Tables.mdb file on A is in Word 2000 format. If I copy this tables.mdb file onto B, Access on B can readily link to the tables on its own C drive, but this is useless to me because I need network access to A. I tried two solutions: 1. On the A computer, right-click the file with the tables and uncheck the security message box. I couldn't find this box. 2. Get into the "Trusted sites" window on Computer A and add the network name of the computer B ("CMAYHEW"), and be sure the "Require server verification" box is unchecked. I did that. I also then rebooted Computer A. No luck. Thanks. Frustrated in New Jersey (but aren't we all?). |
|
|
|
#2
02-27-08, 06:09 PM
|
|
|
|
|
One more thought. Do I have tghis bass-ackward? I had thought that it was
Computer A (that has the tables) that wouldn't let Computer B's Access program link to them. Is the problem that Access on B doesn't trust A? And should I have tried all these fixes on B rather than A, that is, telling B that A is an OK site? |
|
#3
02-27-08, 07:55 PM
|
|
|
|
|
If your app is on B and the data is on A, then B has to trust A.
|
|
#4
02-28-08, 08:52 AM
|
|
|
|
|
Hi Peter,
Think you 'got it' - If the file is on A then B has to be trusting A. A needs to be sharing the folder, but you appear to have that part working according to your description. Gordon "Pete Brady" <PeteBrady> wrote in message news:9d7f [..] |
|
|
| Similar Threads | |
| Checks posted to GL - status as 'work' - AP invoices still open I posted a check batch and it posted through to the GL, however, when I do an inquiry on the vendor - the payment shows as 'work', there is no check number associated with... |
|
| Screensaver does not work, tried all the solutions posted I have Win XP Pro at work and the screensaver stopped working months ago, however, been too busy to do any real troubleshooting. I have read all the posts and none of those... |
|
| After trying all kinds of posted solutions I still get 0x80070005 After trying all kinds of posted solutions I still get 0x80070005 I checked that updates service and BITS service are running. There are no event messages related to these... |
|
| Solutions for questions posted through discuss board Could you let your engineers to look around the posts periodically, then give out answers for some of the popular questionss? Regards Thomas Ge |
|
| IIS 5.1 will not display default page! Posted solutions not working. Typed http:\\webSiteName\\default. received error( Cannot find server or DNS Error ) I was able to ping the server and get a reponse with the IP address. I have gone though... |
|
|
All times are GMT. The time now is 05:05 AM. | Privacy Policy
|
Cannot open file, posted solutions don't work.