Microsoft Office Tutorials and References
In Depth Information
Splitting Your Database into a Front End and a Back End
5. Type a name for the back-end database, and click the Split button.
The wizard suggests the name of your original database, followed by -be
(for back end) . You may want to use the original name plus Data .
Access creates a new, empty database with the name you specify. It
exports every table from your original database to this new database,
including the relationships among the tables, and then creates links
from the original database to the tables in the new back-end database.
The original database becomes the front-end database.
The wizard displays a message when it finishes, indicating whether the
split was successful.
6. Click OK to close the wizard.
If you open the back-end database directly in Access, you find only tables —
no queries, forms, reports, macros, or VBA modules. If you open the original
database (which is now the front end), the tables are replaced by links to the
tables in the back end.
Handing out front ends
Each person who uses your shared database needs a copy of the front-end
database on his or her computer. (You can open a front-end database from
a shared folder, but it loads and runs much more slowly.) You can copy
the front end to each person’s computer, or copy the front end to a shared
folder and tell everyone to copy the file.
Before you pass out the front-end database, consider saving it as an .accde
file so that people can’t accidentally mess up the forms, reports, or VBA
code. (See Chapter 3 of this minibook for details on saving a database file as
an .accde file.) If you do, save a copy of the .accdb file, too, so that you
have a way to make updates.