Unable to update .MDB file over network using 2008 R2

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
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.