ACC2000: TransferText Can't Import Data into Enabled 2.0 Database (208226)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q208226
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you use the TransferText action in a macro or in a Microsoft Visual Basic procedure to import data into an enabled Microsoft Access 2.0 database in Access 2000, you may receive the following error message:
You can't import objects into a database created in an earlier version of Microsoft Access.
This behavior does not occur if you use TransferText to import data into an enabled Access 7.0 database in Access 2000.

RESOLUTION

You can work around this issue in two ways:
  • Use Access 2.0 to import the data into the database.
  • Convert the Access 2.0 database to the version of Access that you are using.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Using Notepad or another text editor, create the following new text file, and then save it as C:\My Documents\Customer.txt:
       "ALFKI","Alfreds Futterkiste"
       "ANATR","Ana Trujillo Emparedados y helados"
       "ANTON","Antonio Moreno Taquerias"
    					
  2. Start Access 2.0 and create a new database called Transfer.mdb.
  3. Create the following new table in Design view:
       Table: Customers
       -------------------------------
       Field Name: CustomerID
          Data Type: Text
          Field Size: 5
          Indexed: Yes (No Duplicates)
       Field Name: CompanyName
          Data Type: Text
          Field Size: 255
       Table Properties: Customers
       -------------------------------
          PrimaryKey: CustomerID
    					
  4. Save and close the Customers table.
  5. On the File menu, click Imp/Exp Setup.
  6. Without modifying the default values in the Import/Export Setup dialog box, click the Save As button, and then save the specification as Cust. Click OK to close the dialog box.
  7. Create the following new macro called ImportCustomers:
       Macro: ImportCustomers        Action
       -------------------------------------------
                                     TransferText
        ImportCustomers Actions
       -------------------------------------------
       TransferText
          Transfer Type: Import Delimited
          Specification Name: Cust
          Table Name: Customers
          File Name: C:\My Documents\Customer.txt
          Has Field Names: No
    					
  8. Save the macro, and then run it.
  9. Open the Customers table in Datasheet view and verify that it contains the three records from the text file that you created in step 1.
  10. Delete all three records from the table.
  11. Close the table, and then quit Access.
  12. Start Access 2000, and then open the Transfer.mdb database.
  13. In the Convert/Open Database dialog box, click Open Database. Click OK when you see the message that you can't make changes to the database objects.
  14. Click Macros in the Database window and run the ImportCustomers macro.

    Note that the macro does not run, and you receive the following error message:
    You can't import objects into a database created in an earlier version of Microsoft Access.

REFERENCES

For additional information about importing or linking data in an enabled database, click the article number below to view the article in the Microsoft Knowledge Base:

208803 ACC2000: Cannot Import/Link Data in Enabled Database

For more information about converting Microsoft Access databases, click Microsoft Access Help on the Help menu, type conversion and compatibility issues in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about the TransferText Action, click Microsoft Access Help on the Help menu, type transfertext action in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbbug kberrmsg kbnofix kbusage KB208226