Why Split the Database?

Performance is one reason for splitting a database. The forms and reports run locally. Hence, the only information that passes across the network is the data.

 

Archiving is very useful if you have so much data that you exceed your file limit. Splitting the database is not the same as archiving, or moving old records into another database. One method for archiving records is discussed later in this computer guide.

 

Preparation

Try it: Back up Before You Begin

Go to your documents and make a copy of the Front Row Videos database and name it VideoForms.mdb.

 

Make another copy of the database and name it Videodata.mdb.