Our organization has an Access data base. The workers in the office constantly update that data base, and work on it simultaniously on different computers. Recently we have added some workers who work from home and have to update the data base remotely. In order to accomodate for them we had to move over to a server. We acquired a new pc and installed Windows Server 2003 R2 sp3 Enterprise Edition, and placed the Access file on the server.
Once we started working with the server we ran in to strange things.
Firstly, we have found that sometimes when the file is open on one client, noone else is able to open that file at all, not even a read only version. We have tried hard to work out when this happens, but have not been able to isolate the problem to a specific case. We did notice that this doesn't only happen with Access, but also with other files. In the passed when we used a local network only to access the file, we never had this problem, so we wondered what is going on. We have tried giving everybody maximum rights to access the file, but to no avail. Would someone be able to point us in the right direction?
Secondly, in the last week the Access file got corrupted twice. Again this is something which almost didn't happen in the past. Is there anybody who can comment about this?
Thirdly, as the upload speed of the office's internet connection is slow, it proves hard for the remote clients to work with a VPN. So far they have been connecting with Remote Desktop, putting a lot of the burden on the server, plus we are limited to our Terminal Services lisence for the amount of people that can connect concurently. We have been thinking of placing different copies of the data base on the different remote computers and have them all synchronised, but didn't find any software which could do this in real time so that the different workers can all have their copy of the file open and make changes which wil (almost) instantly update all copies without additional intervention. Does anybody know of such software (for reasonable price as we are a charitable organization) or of any alternative way to get the workload done by the remote computers without the need for a huge internet connection, which isn't only expensive, but also, there is no infrastracure in the area of the office to get such fast connection.
Thank you very much indeed,
Its me
Once we started working with the server we ran in to strange things.
Firstly, we have found that sometimes when the file is open on one client, noone else is able to open that file at all, not even a read only version. We have tried hard to work out when this happens, but have not been able to isolate the problem to a specific case. We did notice that this doesn't only happen with Access, but also with other files. In the passed when we used a local network only to access the file, we never had this problem, so we wondered what is going on. We have tried giving everybody maximum rights to access the file, but to no avail. Would someone be able to point us in the right direction?
Secondly, in the last week the Access file got corrupted twice. Again this is something which almost didn't happen in the past. Is there anybody who can comment about this?
Thirdly, as the upload speed of the office's internet connection is slow, it proves hard for the remote clients to work with a VPN. So far they have been connecting with Remote Desktop, putting a lot of the burden on the server, plus we are limited to our Terminal Services lisence for the amount of people that can connect concurently. We have been thinking of placing different copies of the data base on the different remote computers and have them all synchronised, but didn't find any software which could do this in real time so that the different workers can all have their copy of the file open and make changes which wil (almost) instantly update all copies without additional intervention. Does anybody know of such software (for reasonable price as we are a charitable organization) or of any alternative way to get the workload done by the remote computers without the need for a huge internet connection, which isn't only expensive, but also, there is no infrastracure in the area of the office to get such fast connection.
Thank you very much indeed,
Its me
I was too slow this time.
