Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    'Access Denied' Message (XP Pro)

    One of those frustrating days.

    Working with a new client. Peer-to-Peer network, "server" is XP Pro, and I think other workstations were also XP Pro.

    On the server/workstation, I copied 2 Access databases (a frontend and backend) to new filenames within the same directory. I made some minor changes and relinked them. Everything worked fine.

    I then went to another workstation and tried to copy the frontend db down to a local drive, but got an "Access Denied" message, indicating file space full, or in use by another user, etc. As it turns out, I couldn't do anything with the new databases from the workstation; I couldn't open them, I couldn't rename them, I couldn't copy them. Same situation at the other 4 workstations!

    This seemed to be some sort of permissions problem, but I don't understand what. I could still do anything I wanted with other files within that same server directory from any of the workstations! Almost like there was a file-level permission that was denying access to the files, but there isn't any file-level security, is there? (other than the Read-only property, which was not set).

    From the server, I happened to make a copy of one of the "offending" databases, and voila! All workstations could open that copy! So I just renamed both databases, made copies back to the original filenames, and all the workstations were fine and dandy, I could even open the database simultaneously from 2 or more workstations!

    Does anyone know what I was running into?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Access Denied' Message (XP Pro)

    Rather frightening, isn't it, to see "Access denied" when you try to work with Access.

    If you right-click one of the problem databases and select Properties, is there an Unblock button near the bottom of the dialog?

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Access Denied' Message (XP Pro)

    I don't recall seeing any "Unblock" button or checkbox, only the "Read only" and "System" checkboxes.

    I'm wondering if rebooting the "server" might have helped? I did read in MSKB about a situation that produces similar error in which a file is being cached by another workstation. If I ever get back there, I may see what I can discover; it is a little easier when the pressure is off.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'Access Denied' Message (XP Pro)

    > I'm wondering if rebooting the "server" might have helped?

    Certainly! Sometimes a file remains locked after having been used by another user.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Access Denied' Message (XP Pro)

    Mark,

    A bit late, but if you run into this again, here's another possibility. I had much the same problem last week with a few machines.

    The local intranet zone was not allowing me to 'acess' the database. So in IE7, I had to go to Internet Tools and Security. I had to add the 'server' machine to the intranet trusted zone and all is well again.

    I didn't have time to stop and wonder why or how come all of a sudden. (And now I've moved on ...)

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 'Access Denied' Message (XP Pro)

    Well, that is really strange, but then no stranger than what I did that "solved" that problem. I'll definitely keep it in mind for next time. Thanks.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •