Figure 21-6 shows the familiar Explorer-style file dialog box that lets you specify the
location of the back-end .accdb file. By default, the back-end database has the same name as the
original database with a _be suffix added to the name (for example, MyDB_be.accdb). You
should plan to put the back end exactly where it will reside in the production environment.
Because the front-end database will contain links to the back-end database, and because links are
path-specific, the links would have to be refreshed if the back end were moved after being built by
the Database Splitter.
FIGURE 21-6
Specify the permanent location of the back-end database in the Create Back-end Database dialog box.
697
Building Multiuser Applications 21
When you click on the Split button shown in Figure 21-6, the Database Splitter database creates
the back-end database, exports all tables to it, deletes the tables in the local database, and creates
links to the back-end tables. In other words, the Database Splitter performs precisely the same
steps you??™d have to perform manually if the Database Splitter weren??™t available.
Pages:
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367