The information in this article applies to:
SYMPTOMSIf you create a table with an SQL action statement such as SELECT INTO, the new table is not immediately reflected in the TableDefs collection of the database object or property. This may result in the error "Name not found in this collection" (error 3265). WORKAROUND
Perform TableDefs.Refresh immediately after creating the new table.
The Refresh method should be but is not documented for the TableDefs
collection in the Visual Basic manuals or Help menu.
STATUSThis behavior is by design. MORE INFORMATIONA table created with an SQL statement is correctly reflected in the Tabledefs collection after the database is closed then reopened. Steps to Reproduce ProblemThe following program demonstrates this problem. It results in the error "Name not found in this collection" on the Tabledefs.Delete statement.
Additional query words: 3.00 docerr
Keywords : |
Last Reviewed: August 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |