Article ID: 295231 - View products that this article applies to.
This article was previously published under Q295231
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
When you try to upsize a Microsoft Access database (.mdb) to Microsoft SQL Server, the Upsizing Wizard does not export data for large tables.
The ODBC pass-through query that Microsoft Access uses to export the data is timing out.
The following section describes a resolution to the issue and involves changing the registry. If you do not want to make changes to the registry, there is also a workaround for this issue, which is described after the resolution.
To resolve this issue, set the QueryTimeout value in the registry to 0. This keeps the query from timing out. To set the QueryTimeout value to 0, follow these steps:
WorkaroundTo work around this issue, follow these steps:
For additional information about how to use DTS, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/285829/ )How to Use Data Transformation Services (DTS) to Export Data from a Microsoft Access Database to an SQL Server Database
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
When it upsizes a Jet database to Microsoft SQL Server, the Upsizing Wizard uses SQL ODBC pass-through queries executed through the Jet database engine. The QueryTimeout value in the registry specifies how long (in seconds) ODBC queries may execute before timing out. By default, the QueryTimeout value is set to 60 seconds. Therefore any ODBC pass-through query that takes more than 60 seconds times out, and the Upsizing Wizard skips the operation.
Steps to Reproduce the Behavior in Access 2003NOTE: The following steps simulate the behavior upsizing the Northwind sample database by setting the QueryTimeout to 1 second. This causes any ODBC pass-through queries to timeout after 1 second.