Multiple Users Updating a Database

[evan_panagiotopoulos]

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

[andygaunt]

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

[Keith M. Davie]

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.

[IdealData]

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

[Anatoli]

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.