Article ID: 124239
Article Last Modified on 11/6/2000
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q124239
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you try to link (attach) a SQL Server table, you may receive the following error message:
CAUSE
This problem occurs only if you have installed the Microsoft Access version 2.0 Service Pack. This problem is caused by the Microsoft SQL Server ODBC driver, but occurs only if you are using the Microsoft Jet database engine version 2.5, which is installed with the Service Pack. The problem with the SQL Server driver causes the Microsoft Jet database engine version 2.5 to be unable to link (attach) any table with a name with the following pattern:
(number of non-underscore characters in table name) + ((number of
underscores in table name) x 3) >= 33
Therefore, you can link a table with the name
a_bceghi_jklopq_stuv_x24
but you cannot link a table with the name:
a_bcdeghi_jklopq_stuv_x25
RESOLUTION
To work around this problem, rename the table so that it does not have a name matching the pattern described in the "Cause" section. Or, create a SQL Server view based on the table and then link the view. For example, you could use the following sample SQL statement to create a view:
create view AbcDefGhiJklMnoPqr
as
select * from abc_def_ghi_jkl_mno_pqr;
You could then link the view instead of linking the table. In order to update the view, you would need to create an index specification on the view, as in the following example:
create unique index Index1 on <owner>_AbcDefGhiJklMnoPqr (field1)
For more information about this type of index, please see the Microsoft Access "User's Guide," version 2.0, Chapter 9, "Importing, Exporting, and Attaching," page 169.
STATUS
This problem no longer occurs with the ODBC SQL Server driver that ships with Microsoft Access 7.0 or 97 and SQL Server 6.x.
REFERENCES
For more information about the Microsoft Access version 2.0 Service Pack, please see the following article in the Microsoft Knowledge Base:
122927 WX1124: Microsoft Access Version 2.0 Service Pack
For more information about the latest ODBC drivers available, please see the following article in the Microsoft Knowledge Base:
147192 ACC: Where to Get Oracle and SQL Server ODBC Drivers
Additional query words: jet25 jet 2.5
Keywords: kberrmsg kbbug kbusage KB124239
