Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Microsoft Access can't open this file.

by philmanson Oct 23, 2007 1:54AM PDT

I have just introduced a network into my office comprising 2 user computers and a server. The server only has data on it.

One item I moved to the server is an MS Access database which i have been using for many years running MS Office XP Pro.

When I attempt to open the file from my computer I get the following message:

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.

I need the file on the server so that it can be shared and the data backup runs from there.

Can anyone offer some help/advice please.

Thank you

Philip

Discussion is locked

2 Posts

- Collapse + Expand Details

- Collapse -

Re: MS Access can't open file.

by Kees Bakker Oct 29, 2007 8:50PM PDT

Does http://support.microsoft.com/kb/810582 apply?

If so, you've got 3 possible solutions:
1. The one in this article: use data access pages. This requires programming.
2. The one in http://support.microsoft.com/kb/303650/ : changing advanced security settings.
3. Use a mapped drive (like i:\data\access) instead of an url to open the file.

Hope this helps.

Kees

Kees