Access' Network Capability

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

My question deals with how Access 2000 handles the
processing of data when more than one user is logged onto
the database. Will data corruption be an issue?

For example, if three users are logged on and working on
a form that uses the same table, and they all modify the
same field and click save....whose moification would be
really saved?

Thanks in advance for any useful info

Tony
 
Tony said:
My question deals with how Access 2000 handles the
processing of data when more than one user is logged onto
the database. Will data corruption be an issue?

For example, if three users are logged on and working on
a form that uses the same table, and they all modify the
same field and click save....whose moification would be
really saved?
Click to expand...

If they are each on separate records..then all 3 will have their data saved.

If all 3 people are on the SAME record, then it depends on how you setup
record locking. Assuming the default, the first person would get their data
saved, and the other two people would get a warning that the data has been
changed, and do you want to save your data to the clip board.

So, there are record locking systems, and things that do handle the
collisions for you. This means that ms-access (the JET engine) can handle
multi-users situations.
 
Back
Top