Abhijeet Gudur wrote:
On Thursday, 30 January 2014 09:16:27 UTC+5:30, witek wrote:
Abhijeet Gudur wrote:

On Wednesday, 29 January 2014 01:54:32 UTC+5:30, witek wrote:

Abhijeet Gudur wrote:



Apart from Excel Web App and sharing on network, how can we share a file with multiple users.







For example, I am working on a status report and it changes every hour. Distributing reports every hour through email will be difficult to track progress or changes, 8-10 files everyday and 200 copies over a period of month.







Please suggest other options. Thanks.











website + database



Thanks for your response. Trying Excel(front end) + DB.





it works if you do not have concurrent users trying modification of the

same data at the same time. Unless you know how to play with record

locking in access.



For read only/ view only, especially when data goes to excel table or

pivot table which can be automatically refreshed that can be the

easiest thing to do.

Thanks for your thoughts.They are right and mutual.Team of five will access the DB through excel file(macro to get and send updates).Restricting access at excel level, one user cannot see data of another user. So even if they send update to DB it will update just their records. And yes, they will not be accessing at once since they work in different shifts/Time zones. Am I missing something ??


it should work as long as they do not try update the same data.