Show All

Hide All

1. Open the Microsoft Access database you want to upsize.

   How?

   1. On the File menu, click Open .
   2. Click a shortcut in the left side of the Open dialog box, or in the Look in box, click the drive or folder that contains the Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) that you want.
   3. In the folder list, double-click folders until you open the folder that contains the database.

      If you can't find the database that you want to open, click Tools on the toolbar in the Open dialog box, and then click Search . In the Search dialog box, enter additional search criteria.

   4. Do one of the following:
      • Double-click the database.
      • To open the database for shared access in a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) environment, so you and other users can read and write to the database, click Open.
      • To open the database for read-only access so that you can view it but cannot edit it, click the arrow next to the Open button, and then click Open Read-Only.
      • To open the database with exclusive (exclusive: A type of access to data in a database that is shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.) access, click the arrow next to the Open button, and then click Open Exclusive.
      • To open the database for read-only access and also prevent other users from opening it, click the arrow next to the Open button, and then click Open Exclusive Read-Only.

   Note  You can directly open a data file in an external file format such as dBASE, Paradox, Microsoft Exchange, or Microsoft Excel. You can also directly open any ODBC data source (ODBC data source: Data and the information needed to access that data from programs and databases that support the Open Database Connectivity (ODBC) protocol.), such as Microsoft SQL Server or Microsoft FoxPro. Access automatically creates a new Access database in the same folder as the data file and adds links to each table in the external database.

   Tips

   • To open one of the last several databases you had open, click the file name at the bottom of the File menu. Microsoft Access opens the database with the same option settings it had the last time you opened it. If the list of recently used files isn't displayed, click Options on the Tools menu, click the General tab, and then select the Recently used file list check box.

   • To view a list of shortcuts to databases that you have opened previously, click My Recent Documents on the left side of the Open dialog box.

2. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.

   If the wizard doesn't start

   This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

   For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later, at http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010489351033.

   For more information about sandbox mode, see the topic About Microsoft Jet Expression Service sandbox mode.

3. Follow the directions in the Upsizing Wizard pages and dialog boxes, and then click Finish when you are done.
4. If you need more information to decide what to do in each page of the wizard or dialog box, click Help.

The Upsizing Wizard will run to completion after you click Finish; there are no additional prompts. This is especially useful if you want to upsize a large database unattended. If you need to cancel the upsizing process, click Cancel on the status box that the Upsizing Wizard displays after you click Finish. Any error messages are written to the Upsizing Wizard report, created as a report snapshot (report snapshot: A file (.snp extension) that contains a high-fidelity copy of each page of an Access report. It preserves the two-dimensional layout, graphics, and other embedded objects of the report.) with the same name as the Access database (for example, Northwind.snp), and stored it in the default database folder.