Microsoft KB Archive/243464

= ACC2000: CommandTimeOut Expired Error When You Try to Make a Design Change to an Access Project =

Article ID: 243464

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q243464



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
In an Access project, when you try to make a design change to a very large table (in most cases in excess of 1 million records), you may receive the following error message:

Errors were encountered during the save process. Some of the database objects on your diagram were not saved.

'  and PWD= ''' to the correct values. Make sure that the user ID has the appropriate permissions to perform this operation on the database. Function MakeTestTable Const DB = "DRIVER={SQL Server};SERVER=Chriswy1;UID= ;PWD= ;DATABASE=northwind" Dim cn As ADODB.Connection

Set cn = New ADODB.Connection cn.Open DB On Error Resume Next SQL = "DROP TABLE tblLarge" cn.Execute SQL On Error GoTo 0

SQL = "SELECT * INTO tblLarge FROM [ORDER DETAILS]" cn.Execute SQL

SQL = "INSERT INTO tblLarge (OrderID, ProductID, " _     & "UnitPrice, Quantity, Discount) SELECT " _ & "[Order Details].OrderID, [Order Details].ProductID, " _ & "[Order Details].UnitPrice, [Order Details].Quantity, " _ & "[Order Details].Discount FROM [Order Details];" For I = 1 To 500 cn.Execute SQL Next I

MsgBox "Finished Creating Table tblLarge."

End Function  In Access 2000, create an Access project that is based on this database. In Design view of the tblLarge table, try to make the first field a primary key. Save the changes and wait several seconds. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.

