Multi person access

[Wild Bill]

I am using Access 2000, I need to have multi-users in the
same form at the same time. Is this an issue of whom
changes a record if two users are attempting to change the
same record. How can this be handled or is there a built-
in safety with Access 2000 where I don't need to concern
myself with this issue? Please advise. Thanks in advance.

 

[Jonathan Parminter]

-----Original Message-----
I am using Access 2000, I need to have multi-users in the
same form at the same time. Is this an issue of whom
changes a record if two users are attempting to change the
same record. How can this be handled or is there a built-
in safety with Access 2000 where I don't need to concern
myself with this issue? Please advise. Thanks in advance.
.

Hi Wild Bill,
firstly in a multiuser environment ensure that you have a
database that is split into a client front end and a back
end. Each user has a separate copy of the client front
end. The back end is located in a shared drive.

To reduce the likelihood of record conflicts force users
to select an individual record using an unbound form. This
unbound form then opens an editing form that has a
recordsource that only contains the single record selected.

Use online help to lookup "locking" and use tools |
options and then switch to the Advanced tab to view
current locking setting. Click ? and then the option to
get a quick description from help.

Well that's the short version on record locking...

Luck
Jonathan