Hi
I'm a student of computer science and i'm working on project. I never worked much in exel but programming shouldn't be a problem i just need to learn the syntax.
What i need is some suggestions on how to get started.
I need to make an exel program(client) for office workers(3 of them) that would be able to store tables ether in a database or just keeping it in the file(it's actualy not a lot of data)
What trubles me is that all 3 users wan't to use the program at the same time. By editing their own table they would be editing the main document that is (shared to all of them).
And if one of them edits a cell the other two must get an update ASAP!
Its basicily an employers list with some properties like % of enployment and other stuff.
The clients must be updated at all time so that situations like an employer beeing employed 100% by one of them and at the same time the other client employes him additional 50% witch can't happen.
So they need to be able to edit their own table witch after saving or pressing a button takes the data and stores it in a shared database. Each of them have diferent fields and cells depending on the office department.
To complicate things a bit more i need to keep history of all tables (edits) for 3 years!
At first i was thinking of simply making a exel shared file so all three can edit it over the local network. But i don't know how to keep track of history, Setting up a database could work but i guess i would have to implement some synhronization since more clients can't read/write the same cell at the same time or some values may get overwriten.
Any ideas (concept) on how to get this done without complicating too much??
The program has to have a REALY friendly interface so that office workers woun't have problems working with it.
I thank you in advance!
Bookmarks