Article ID: 884404 - View products that this article applies to.
When you try to run a Make-Table query or an Append query on a linked Open Database Connectivity (ODBC) Sybase table in Microsoft Access 2002 or in Microsoft Office Access 2003, you may receive the following error message:
Access Reserved Error - 7711: This error has no definition.
This problem occurs when the Select method is set to 1 - Direct in the ODBC Sybase Data Source Name (DSN).
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.
To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=supportNote In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
For additional information about this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/870753/ )Description of the Jet 4.0 Database Engine post-837001 hotfix package: July 21, 2004
To work around this problem, set the Select method to 0 - Cursor in the ODBC Sybase DSN and then re-link the Sybase table. To change the Select method, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.