Sharing Access and security

[Mitsu]

If two people are using Access, how does Access prevent two users from entering data at the same time.

How do I set the security for Access.

Thanks

Appreciate some help.

 

[SydneyGeek]

If two people are using Access, how does Access prevent two users from entering data at the same time.

Access uses record locking to prevent simultaneous changes to the same record. Almost always, more than one record is locked -- the one being edited, and adjacent records up to a page size -- about 32kb (can be more or less, depending on the version of Access). Bottom line, only one user can edit a record at a time.

How do I set the security for Access.

BIG topic! There are many security options out there, but Access has a pretty good user-level security model, based on work groups. For both of these topics, check the Microsoft Knowledge Base.

Denis