• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

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
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )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.

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now