File sharing

[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.

 

[witek]

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

 

[Abhijeet Gudur]

website + database

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

 

[witek]

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.

 

[Abhijeet Gudur]

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 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 ??

 

[witek]

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.

 

[Abhijeet Gudur]

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

Cheers!
happy weekend.