Can several users update a database at the same time?

If I have, for example, if I have formatted a field as a pop-up list can it be updated by several uses?

If a field is edited by a user would a second user get a message indicating that the record is locked?

By the way, I do appreciate the time and effort of the many users who respond to all the questions.

Thanks,

Evan

Evan,

As long as your database is set to multi user then you can have many users modifying that database at the same time.

But if a user is modifying a record, then no other users can make any changes to that record until the current user is not editing a field.

They can look at the record, but they cannot make changes.

So, basically yes they can all use the database but only 1 user can make changes to a specific record at any one time.

HTH

Evan, record locking is a fact of life in 5.5 in a peer-to-peer solution. If you actually want more than one user to be able to edit simultaneously, you might find success through a browser solution. In a browser solution you often can do things which cannot be done in a peer-to-peer soltuion.

Yes, you can break the rules of record locking by using web publishing - but that's very dangerous and purely a quirk of the way web pages are delivered and submitted.

Your update script in FMP should check the StatusCurrentModificationCount on delivery and submission - if they're not the same then reject the submission, otherwise you would over-write the data already submitted by another user

quote:

---

Evan, record locking is a fact of life in 5.5 in a peer-to-peer solution.

---

It is in all versions since v. 1 and also with client server, not just peer-to-peer.