Multiple Users - Novice?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks

Sharkbyte said:
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
Click to expand...
 
Back
Top