File sharing

  • Thread starter Thread starter Abhijeet Gudur
  • Start date Start date
A

Abhijeet Gudur

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.
 
Abhijeet said:
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.
Click to expand...

website + database
 
Abhijeet said:
Thanks for your response. Trying Excel(front end) + DB.
Click to expand...

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.
 
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.
Click to expand...

Thanks for your thoughts.They are right and mutual.Team of five will accessthe 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 theysend 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 Imissing something ??
 
Abhijeet said:
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 ??
Click to expand...

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