|
The Mighty
Access database you have been programming is alllllmost ready to be
released to Real Users. This database works well on one computer.
However, the Front Row Video store has several Point of Sale (POS)
computers so that many customers can pay quickly. Is there a way that
all of the POS computers can share the same database?
Yes!
Microsoft
Access can support hundreds of Users in many locations. Access has
record locking so that two Users don't accidently edit the same record
at the same time. This lesson
looks at ways to split the database into two databases: one with the Tables and
the other with everything else. First, we'll
analyze the Tables and discuss the options. Then, we'll optimize the
database for performance in a multiuser network. Finally, we'll
look at the database security and maintenance. |
|
| |
