Software

Ask something
Question Locked

Copy file to dest. and overwrite open file?

0 helpful
5 replies

by 1bn0 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by ---tk---

schedule a task to run a .bat that copy's and replaces the old access file... or you could have it delete the file then copy the file over... thats what I would do...

by robo_dev

Have you considered upgrading to a database such as SQL server or even MySQL?

Instead of a batch file to copy the Access DB to another Access DB, just port the Access DB into MySQL or Microsoft SQL server. Your users will love you for it....

by 1bn0

But the file has been around for al ong time. This data is supposed to end up in Sharepoint, but we have to live with it for a while yet.

by 1bn0

A scheduled task was what I had in mind. But the users keep leaving the file open and locked so Windows won't allow you to replace it.

This discussion is closed to new replies.