ACC: Cannot Import/Link Data in Enabled Database

 Last reviewed: June 3, 1997
Article ID: Q135372
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

SYMPTOMS

In Microsoft Access, when you open a database created with a previous version of Microsoft Access without converting the database, you are unable to link or import data. You see one of the following error messages:

In Microsoft Access 97: 

   The Get External Data command on the File menu is unavailable.
In Microsoft Access 7.0: 

   The Import command on the File menu's Get External Data submenu is
   unavailable.

RESOLUTION

You can either convert the database to the version of Microsoft Access you're opening it with or use the version of Microsoft Access the database was created in to open the database and import the data.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Microsoft Access.

  2. Open a database created with a previous version of Microsoft Access.

  3. In the Convert/Open Database box, select the Open Database option and click OK.

  4. In Microsoft Access 7.0:

    Click Get External Data on the File menu. Note that the Import subcommand is unavailable.

    In Microsoft Access 97:

    Click the File menu. Note that the Get External Data command is unavailable.

REFERENCES

For more information about opening Microsoft Access databases created in previous versions of Microsoft Access, search the Help Index for "opening databases, created in previous versions of Microsoft Access," or ask the Microsoft Access 97 Office Assistant.

Keywords : CnvRunPre IsmIea kbinterop kbusage
Version : 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.