Updating Access tables locked out by other users
-
10 Mei 2012 14:34
I must update several Access tables daily which are shared with several co-workers via Excel. However, if someone has an excel document open (read-only)that is pointing to the Access table that I am updating I am unable to overwrite the Access table due to being locked by other user. Is there a way to close their program so that I can update?
Semua Balasan
-
11 Mei 2012 1:16
This sounds more to me like a people problem than a technical problem....
Do you WANT to reach out to your coworkers' workstations and close files they have opened and might be using? Really? Don't you think that might lead to friction in the workplace?
With Joy Wend Your Way
-
11 Mei 2012 11:41I appreciate your concern and under different circumstances that would cause friction. However, the file they are accessing is a read-only, not a working document. In addition, they have been told that it needs to be closed in order for updates and yet they continue to open and leave it open while not in use. Is is possible to give them a warning that the file will close in 5 minutes for updates and then close the file?
-
11 Mei 2012 16:30
Yes, but you are not going to be able to reach over to their desktops and close the Excel file for them. At least, I can't imagine that that is possible in most workplaces.
You are controlling the ACCESS file, not the EXCEL file which they open independently, correct? In other words, they launch Excel and then open this shared Excel file in read-only mode. It may be possible, but I don't know of a way to kill a process on someone else's computer. (seems sort of dangerous to me anyway)
You probably can send them a message asking them to close it and if that doesn't work, call them, and then their supervisor.
With Joy Wend Your Way
-
11 Mei 2012 16:49I appreciate your deep concern for my working relationships George; however, your responses are not much help. I am looking for a way to improve productivity and lessen down time. By having to contact every employee that has opened a file that is only used as a reference tool is not effecient. Each report that is run is dependent on the information captured from the previous report. Therefore, when one file is locked the entire system shuts down. I do know that there are ways of closing files through the main server, but rather than having to depend on the IT dept., I would like to know if there is a way that it can be done on my end.
-
11 Mei 2012 17:17
Can YOU close files on your co-workers' computers at ANY time without taking control over their computers? That's the issue here. I am not aware of a way to do that. I know that IT can control desktops for all of their users; that's their job. I don't know that YOU will be given admin rights to do that on your coworkers's desktops, even if you CAN find a way to do so from VBA running on your desktop.
Here's a list of articles on this topic. Maybe you'll find some code you can use there. It's mostly about managing Access to Access, but you ought to be able to adapt.
Also, you might ask your own IT folks to help you figure out the permissions issue for your coworkers' computers. My "concern" comes from trying to put myself in the position of one of your coworkers who suddenly finds a file they've been using has closed itself with no warning. I realize your concern is coming from a different perspective. The goal, though, should be to make it work efficiently as well as smoothly.
With Joy Wend Your Way
- Diedit oleh George HepworthMVP 11 Mei 2012 17:18
- Ditandai sebagai Jawaban oleh Jaynet ZhangMicrosoft Contingent Staff, Moderator 14 Mei 2012 9:30
.png)
