Unable to update .MDB file over network using 2008 R2

Posted on 2011-10-19
Last Modified: 2012-05-12
I have an application that needs to publish PDF's to a network share, and upon doing so this should then update an MDB file located within the same share.

I have a windows 2008r2 server with the program on, this published to my file server, also windows 2008r2. I can publish ok if i log in as a domain admin and then log in as the user, thus it is down to some sort of windows permission that i am not aware of.

The user has full read write access to the share (and this works as they are able to write the pdf and modify the pdf) but they can not change anything on the .MDB file itself (I have checked the file permissions, they are also ok, with the users having full rw access)

any ideas
Question by:RPUKsupport
    1 Comment
    LVL 84

    Accepted Solution

    Users must have full rights on the FOLDER hosting that file - be sure of this, since your issue sounds exactly like a permissions issues. Also, if you're dealing with folder virtualization, be sure that you're working with the correct database.

    Be sure that someone is not opening the database in exclusive mode. This can lock other users out.

    Also be sure that the .ldb file (the LockFile for Access) is being deleted. This file is located in the same folder as the database, and is named the same as the database - so if I have a db named MyDatabase.mdb, the lockfile would be named Mydatabase.ldb. When everyone is out of the database, Access should delete that file. If it doesn't, the you can try to manually delete it.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    745 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