• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Sharing a Database

When a limited number of people are working on a local area network (LAN), sharing a database is easy. You simply place the database file in a folder that everyone can access, and then limit who can do what to the database by using the same network security you use to protect other information on the network. The number of people who can share a database in this manner depends on how many access it at the same time and what they want to do.

Access manages multiple users fairly well, but you will want to take precautions to prevent multiple users from attempting to update the same record at the same time. For example, if more than one employee at The Garden Company tried to change the same record in the Products table at exactly the same time, the results would be unpredictable if no precautions were in place. For small groups of people, you might want to implement pessimistic locking, which locks a record for the entire time it is being edited. For larger groups, you might want to implement optimistic locking, which locks a record only for the brief time that Access is saving the changes.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint