advice on best way forward

C

Chris

I currently use a excel spreadsheet to store data and have set it up on a
web folder to allow access to other users to view and change data. This
method is not the best way since only one user can change the data at a
time. What are the alternatives where users can access the data and change
it whether someone else is using the file or not? Would access be the best
way forward?
 
C

Chuck

This is a very big problem. It turns out that only one user can have
permission to change the file at a time. Others should have read only.
It's a bit difficult to have a file open for write to multiple users. You
get into having only one record open to a user, instead of the whole file,
and all that rot.

There are ways, but they generally can result in a corrupted file if not
properly accomplished.
(locking records, not files.)
This is a problem that has existed since there have been multiple users and
data bases.
 
Top