We have an access database file that is used for document tracking. A small number of user have read write access. WHne a read only user opens the file this prevents the file from being updated.
As the number of read only users has incresed significantly. They decided to post a “read Only” copy to a different folder.
The problem is the “Read Only” copy needs to be updated daily. It is being done manually but they still can’t overwrite the destination if it is being used.
They are requesting a method to copy the file over at night automatically.
Does anyone know a program or method that will allow copying the file and overwrting the destination even if someone has the file open? Forcing the destination file closed is acceptable.
