Database Reference
In-Depth Information
10
In the message box, click
OK
.
11
When the
Password Required
dialog box is redisplayed, enter the correct password,
2013D@t@b@se!
, and then click
OK
.
Now let's remove the password.
12
Display the
Info
page of the
Backstage
view, and click
Decrypt Database
. A mes-
sage warns that the password cannot be removed unless the database is open for
exclusive use.
13
Click
OK
, and then close the database without exiting Access.
14
Open the database for exclusive use, entering the password when prompted.
15
On the
Info
page of the
Backstage
view, click
Decrypt Database
. Then in the
Unset
Database Password
dialog box, enter the password, and click
OK
to remove the
password.
CLEAN UP
Close the database to release the exclusive use.
Splitting databases
When a database user works over a network on a database that is not stored on his or her
own computer, Access has to move database objects over the network from the computer
where the objects are stored to the computer where the user is working on them. If several
people are working on the database at the same time, processing times can get noticeably
slower. Under these circumstances, you might want to consider splitting the database to
speed up performance.
Splitting a database involves organizing the database into two parts:
▪
Back-end database
Contains the tables that store all the data. It remains on the
network computer.
▪
Front-end database
Contains the forms, queries, and reports that people use to
work with the data. It is copied to the local computer of any user who needs to work
with the database.
