Microsoft KB Archive/225862

= ACC2000: You Cannot Expand Subdatasheet View of a Table That You Imported from Another Database =

Article ID: 225862

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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 ' ' 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.

