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:
Note 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:
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:
Click Start, click Run, type Odbccp32.cpl, and then click OK.
In the ODBC Data Source Administrator dialog box, click your Sybase DSN, and then click Configure.
In the ODBC Sybase Wire Protocol Driver Setup dialog box, click the Performance tab.
In the Select Method box, click 0 - Cursor, and then click OK.
To re-link the Sybase tables, follow these steps:
Start Access. Open the Access database.
On the Tools menu, click Database Utilities, and then click Linked Table Manager.
In the Linked Table Manager dialog box, click the linked Sybase tables that you want to update, click to select the Always prompt for new location check box, and then click OK.
In the Select Data Source dialog box, click your Sybase DSN, and then click OK.
Complete the log on information in the Logon to Sybase dialog box, and then click OK.
In the Linked Table Manager dialog box, click OK.
Note The previous steps may be different in your environment. This depends on the version of the Sybase ODBC driver that you use. The ODBC Sybase DSN can be any one of the following:
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.