Microsoft Office Tutorials and References
In Depth Information
Splitting Your Database into a Front End and a Back End
What if some people have older
versions of Access?
Be aware of which Access version you use
for your database files. Access 2013, 2010, and
2007 use a different file format from earlier
versions of Access. If anyone uses older versions
of Access, you have two options: Upgrade this
person to Access 2007 or later, or make your
database readable by earlier versions. You can
choose to create your database in Access 2000
format, Access 2002–2003 format, or Access
2007–2013 format. (If people are using versions
of Access earlier than Access 2000, make them
upgrade: Too much has changed since Access
95 and Access 97!)
If you have to support older Access users,
your back-end database must be stored in the
appropriate format. In Access 2013, choose the
appropriate file format when you’re creating
your database: Click the File tab on the Ribbon,
click New, click Blank Database, browse to the
folder where you want to store the database,
and set the Save As Type option in the File
New Database dialog box to the appropriate
version of Access. Put this older-format
database in the shared folder that everyone links to.
Fortunately, because of the differences in the
file extensions, these older versions can have
the same name and reside in the same location
as your Access 2013 versions.
You also need to create a front end in the same
version of Access as the back end that you just
created. Usually, the best idea is to maintain as
many front ends as you have database users:
one version in Access 2013, one in Access 2003
(for your version 2002 and 2003 users), and one
in Access 2000 (for your version 2000 users).
Tell your users to copy the appropriate version
to their computers for their own use.
Having said that, maintaining multiple versions
of the same database is a really bad idea.
Persuade management to upgrade
everybody to the latest version, which will save you
3. Click Access Database in the Move Data group on the Database Tools
tab of the Ribbon.
The Database Splitter Wizard appears, as shown in Figure 2-1, explaining
4. Click the Split Database button.
You see the Create Back-End Database dialog box, which looks just like a
Save As dialog box.