Converting a Database to Format

The title bar of the Database window indicates the database file format. Notice the Access 2000 file format in Figure 16-10.

Ready

Figure 16-10

Ready

Figure 16-10

If your database is the 2000 format, convert it to the 2002-2003 format before making the MDE.

Tip: If you wish to always create databases in the 2002-2003format, you can change the default file format through the Advanced tab of the Tools | Options dialog box.

To convert your database to the 2002 format, select Tools | Database Utilities Database | To Access 2002-2003 File Format ...as shown in Figure 16-11.

Convert

To convert your database to the 2002 format, select Tools | Database Utilities Database | To Access 2002-2003 File Format ...as shown in Figure 16-11.

The Convert Database Into dialog box displays options for you to specify the destination file for the new format. Enter the name of the destination file and click Save. The conversion begins immediately.

After you have converted the database (to the 2002-2003format), it can no longer be shared with Access 2000 or Access 97 users.

With the database in the 2002-2003 format, you can now build an MDE file. Be aware that when you create an MDE, you will not be able to import, export, create, modify, or rename any forms, reports, pages, or modules in the MDE file itself. Therefore, you should retain the original MDB file in the event changes need to be made in the future. Obviously, at that time, you will need to make the changes to the MDB, and then create a new MDE to distribute.

To begin the Make MDE file process, select Tools | Database Utilities | Make MDE file ...as seen in Figure 16-12.

Ready

Figure 16-12

Ready

Figure 16-12

The Save MDE As dialog box displays for you to specify the destination file for the MDE. Enter the name of the file you wish to create and click Save. The MDE file will be created.

Was this article helpful?

0 0

Post a comment