Solved

can't open mdb file on network drive

Posted on 2004-10-28
611 Views
Last Modified: 2006-11-17
I have one PC on a network with 10 others - this one machine cannot read any mdb files on our shared projects drive.
It's a Windows sbs 2003 server with XP Pro PC's Access is version 2002

If I copy the mdb file locally it works fine. I can load any mdb file from any other network drive except from my projects drive and this problem occurs on 1 machine in teh 10 on the network.I can load word or XL files ok on the projects drive.

When I use explorer to launch the file it comes up with a File Downlaod open/save option with a warning about opening unknown files. I continue to open, launch Access and it will not open the file as it tells me teh file is outside my intranet or on an untrusted site.

I have tried all options, it's not an ldb issue, may not be down to access but this may be a network issue but I though I'd try it here first.
0
Question by:richwj
    4 Comments
     
    LVL 36

    Assisted Solution

    by:SidFishes
    Make user that every user has full readwrite permission to the folder

    also have a look here

    http://support.microsoft.com/kb/303650/EN-US/
    0
     
    LVL 1

    Accepted Solution

    by:
    oh, I know this one. You have to go to internet option (through internet explorer) and add your network drive to you list of trusted sites.

    just had this problem the other day. only reason my head din't explode trying to fix it was that one of the other guys I work with had just mentioned this problem to mee about a week ago.
    0
     
    LVL 36

    Expert Comment

    by:SidFishes
    you're right Pellanor...that link up ^ there is the MS KB article on the problem ;)
    0
     

    Author Comment

    by:richwj
    thanks guys - appreciate yr help - thought split points was fair....rich
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    860 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

    14 Experts available now in Live!

    Get 1:1 Help Now