The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
Then the table fails to open. CAUSEWhen you link to an ODBC Data Source, the Microsoft Jet database engine calls SQLSpecialColumns for the table you are linking. If SQLSpecialColumns returns a column name, but does not include that column name in the meta- data returned by SQLColumns, an internal state variable for the Column ID of that column is not initialized to a valid value for a Column ID. When you try to open the linked table, the Jet database engine tries to get information about the invalid Column ID. If it does not resolve to a column in the meta-data that is returned by the ODBC Driver, the Jet database engine tries to refresh the meta-data, creating a temporary table called TMP%#MAU. That table already exists, so the error message occurs, and you cannot open the table. RESOLUTIONThere are two ways you can work around this problem:
STATUSMicrosoft has confirmed this to be a problem in Microsoft Access 7.0 and 97. This problem no longer occurs in the updated version of the file, Msjet35.dll. The updated version of the file can be obtained from the following sources:
MORE INFORMATION
With the Microsoft Jet database engine version 3.5, the value in the
uninitialized Column ID variable is most often outside the range of column
ordinal values, so the special column is not found and the Jet database
engine tries to refresh the meta-data. However, this occurs within the
meta-data refresh code itself, and the code is not designed to be called
recursively. So when the Jet database engine tries to create a temporary
table to retrieve the meta-data, it fails because the temporary table
already exists.
REFERENCES
For more information about SQL pass-through queries, search the Help Index
for "pass-through queries," and see the following articles in the Microsoft
Knowledge Base:
Additional query words: link attach thru spt sqlbase gupta centura intersolv
Keywords : kberrmsg OdbcNonms OdbcProb |
Last Reviewed: November 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |