ACC2000: You Cannot Expand Subdatasheet View of a Table That You Imported from Another Database (225862)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225862
Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you expand the Subdatasheet view of a table, you may receive the following error message:
The table or query name 'TableName' you entered in either the property sheet or macro is misspelled or refers to a table or query that doesn't exist.

If the invalid name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro Window, and enter the correct name.

CAUSE

You can only view or edit objects which are directly linked or imported into a database. Tables that are used as subdatasheets are not automatically linked or imported.

RESOLUTION

Do one of the following:
  • Import or link the table that is needed for the Subdatasheet view.

    -or-
  • Remove the reference to the table name from the Subdatasheet Name property.
To remove the reference to the table name from the Subdatasheet Name property, follow these steps:
  1. Open your table in Design view.
  2. On the View menu, click Properties.
  3. Set the Subdatasheet Name property to None.
  4. Save and then close the table.

MORE INFORMATION

When you import or link a table from one database to another, only the table that you select is imported, even if the table uses a subdatasheet. If you specify that a table should have a Subdatasheet view, but then import or link only that table to another database without including the table that is needed for the Subdatasheet view, you receive the error described in the "Symptoms" section of this article.

This same behavior also occurs when you import other dependent database objects, such as a form that has a subform. If you do not import the subform also, you receive a similar binding error.

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Open the Categories table in Design view.
  3. On the View menu, click Properties.
  4. Set the Subdatasheet Name property to Table.Products.
  5. Save and then close the Categories table.
  6. Create a new, blank Access database.
  7. On the File menu, point to Get External Data, and then click Import.
  8. In the Look in box, browse to the folder where Northwind.mdb is stored (by default this is C:\Program Files\Microsoft Office\Office\Samples), and then select the Northwind.mdb file.
  9. Click Import.
  10. In the Import Objects dialog box, click Categories, and then click OK.
  11. Open the Categories table in Datasheet view, and then try to display the Subdatasheet view of any record by expanding the plus sign (+) sign to the left of the Category ID field. Note that you receive the error message described in the "Symptoms" section of this article.

REFERENCES

For more information about subdatasheets, click Microsoft Access Help on the Help menu, type use subdatasheets in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbnofix kbprb KB225862
©2004 Microsoft Corporation. All rights reserved.