multi users editing the same form simultaneously

[Guest]

Is it possible for more than one user to edit the same form at the same time?
If so, would I go about doing this and how would the other user see the
latest information if they were to navigate to the record just updated by
their co-worker?

Also, is there a limit as to how many users can be in the database at the
same time?

Thanks!

 

[SusanV]

As long as 2 people aren't trying to edit the same *record* using a
particular form there won't be a conflict - if you're talking about actually
editing the form design, then only one person can work at a time. Changes
will be seen as soon as a view is refreshed after a data change - i.e.,
moving to a new record in a form, opening a form or report, etc.

 

[Guest]

I am presuming you don't mean 'edit the form' but 'edit the data bound to the
form'?
The first thing you need to do in a multi-user application is to split your
database into a front end and a back end. Each user gets a copy of the front
end.
Yes, two users can edit the data at the same time but the one who saves last
will overwrite the other changes. To protect against this, you need a
timestamp in each record. When the record is read, save the timestamp, just
before saving the record, re-read it and compare the timestamp to the one you
saved. If it has changed, an intervening update has occured and you can
prompt the user to overwrite the changes or not. Obviously, this is a vastly
oversimplified answer to your question.

-Dorian

 

[Guest]

Thanks for your response. I'll do more research and will probably have
questions later.

Thanks again.