Multiple Users - Novice?

[Brian]

Hi All,

I've been reading the posts on here about multiple users. From what I can
gather, once the database is ready you can just split it into a front and
backend using access.

My question is.

If a user has the input form open and is modifying Record 10. If a second
user opens up the form to modify Record 10, will they see the changes that
the first user is making?

Is there any way to alert a user if someone else is modifying a record that
they want to change?

Thanks

Brian

 

[Sharkbyte]

Brian:

There are a couple things that can happen here...

1. If you use Record Locking, then only 1 person can update a record at a
time.
2. If not then the second user will get a message, from Access, stating
that the record they are attempting to access has been changed by another
user, and that they should refresh their data before continuing.

HTH

Sharkbyte

 

[Brian]

Thanks

Brian:

There are a couple things that can happen here...

1. If you use Record Locking, then only 1 person can update a record at a
time.
2. If not then the second user will get a message, from Access, stating
that the record they are attempting to access has been changed by another
user, and that they should refresh their data before continuing.

HTH

Sharkbyte