Problems getting access to a Microsoft Office Access database cross-domain

Posted on 2006-05-30
Last Modified: 2013-12-04
We have some problems opening MO Access files on a another domain I've been giving permission to.
Get an access denied when i try to open. But its no problem to copy it to local drive, and then open it.
But since its a file that many needs to edit on the network, we cant keep copying like this.
I currently have modify access to it, do I need full access maybe?
But it isnt a problem on a word document ex. or any other files. Just the Access databases.
Question by:nesse2006
    LVL 6

    Accepted Solution

    Hi nesse2006,

    If you're running SP2 you need to add the domain hosting the file to your computer's trusted sites list.

    For example, to add to your trusted sites, start Internet Explorer and choose Tools, Internet Options, Security. Then click on the Trusted Sites icon and click the Sites button. In the "Add Web Site..." box type

    Once you've done that Microsoft Access should let you open the database, as it's convinced that it can trust the other domain.



    Author Comment

    Ok, thanks.

    Im gonna give it a try.
    But does this have any effect on a network share?
    We got it mappe as G: , with the IP instead of FQDN.

    Regards, Nesse
    LVL 6

    Expert Comment

    If you're using an IP then you need to add that IP to your trusted sites instead...

    It's a very painful new "feature" that came with SP2...


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    SHARE your personal details only on a NEED to basis. Take CHARGE and SECURE your IDENTITY. How do I then PROTECT myself and stay in charge of my own Personal details (and) - MY own WAY...
    As a Mac user and former AppleCare AHA & Senior Advisor, I'm constantly bombarded with questions about Macs and if they need Antivirus. This short article is my response to those questions.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now