Microsoft KB Archive/304090

= ACC2000: Error When You Export a Microsoft Access Table to Sybase =

Article ID: 304090

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q304090



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you try to export a Microsoft Access 2000 table to a Sybase database, you receive the following error message:

ODBC--call failed.

[Intersolve][ODBC SQL Server Driver](#102)

The same process worked fine in Microsoft Access 97.



CAUSE
You are running Microsoft Jet 4.0 Service Pack 4 (SP4) or earlier.



RESOLUTION
To resolve this problem, install the latest Jet 4.0 service pack.

For additional information about how to obtain the latest Microsoft Jet 4.0 Service Pack, click the article number below to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior

 * 1) On a computer that has Microsoft Jet Service Pack 4 or earlier installed, open the sample database Northwind.mdb.
 * 2) Click the Customers table.
 * 3) On the File menu, click Export.
 * 4) In the Files of type box in the Export To dialog box, click ODBC Databases.
 * 5) Type a name for the table, and then click OK.
 * 6) Select your Sybase DSN.
 * 7) Enter your logon information, and then click OK.

Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Keywords: kberrmsg kbbug kbfix KB304090

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.