pinky33
06-02-09, 03:12 PM
I will try to explain as best I can how and what we are trying to do where I work. The building I am in is government owned and the people that work hear know nothing of networking so the setup I have to start with is not that great. I can tell they just kept adding switches and hubs as different people used the building. Makes me angry to see how some people go around and add to the problem instead of fixing it.
So there is a computer (HP store bought) that is in the LAB. It is full of excel files that are constantly being updated by scientists in the lab. Because the info is only on one computer there sometimes creates a waiting period for people wanting to update there data onto the one computer with said file (excel spreadsheet).
Everyone at work also has there own office with there own computer, most running vista.
I am going to set it up so that the one LAB computer (HP) that has the excel files is shared. And set up so that the files can be edited (read and written too).
MY question FOR YOU
There is an excel file that is updated by many people all day. For now it works fine that each person takes there turn on the one computer and that file is edited and saved by one person and then the next person does there thing. Hence the file is constantly being updated and saved slowly.
If I were to share it over the network what if two or more people opened it and then saved it. Would it only save one of the persons changes?
Example,
Bill is on his computer in his office and opens the excel file that is running off the LAB PC. Bob opens it 2 seconds later in the same fashion (his computer in his office). Bill saves the work to the LAB PC and then goes home for the day. Bob saves his work to the LAB PC 2 seconds later......would it not just overwrite Bills newly saved work????? I mean when Bob originally opened the excel sheet it did not have Bills new data as Bill was in the middle of adding it at the time.
Please tell me if this makes sense.
So there is a computer (HP store bought) that is in the LAB. It is full of excel files that are constantly being updated by scientists in the lab. Because the info is only on one computer there sometimes creates a waiting period for people wanting to update there data onto the one computer with said file (excel spreadsheet).
Everyone at work also has there own office with there own computer, most running vista.
I am going to set it up so that the one LAB computer (HP) that has the excel files is shared. And set up so that the files can be edited (read and written too).
MY question FOR YOU
There is an excel file that is updated by many people all day. For now it works fine that each person takes there turn on the one computer and that file is edited and saved by one person and then the next person does there thing. Hence the file is constantly being updated and saved slowly.
If I were to share it over the network what if two or more people opened it and then saved it. Would it only save one of the persons changes?
Example,
Bill is on his computer in his office and opens the excel file that is running off the LAB PC. Bob opens it 2 seconds later in the same fashion (his computer in his office). Bill saves the work to the LAB PC and then goes home for the day. Bob saves his work to the LAB PC 2 seconds later......would it not just overwrite Bills newly saved work????? I mean when Bob originally opened the excel sheet it did not have Bills new data as Bill was in the middle of adding it at the time.
Please tell me if this makes sense.