Microsoft KB Archive/295205

= ACC2002: Error Importing Table into Access Project Connected to SQL Server 6.5 =

Article ID: 295205

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295205



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

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



SYMPTOMS
When you import a Microsoft SQL Server 7.0 table from an Access project (.adp) into an Access project that is connected to Microsoft SQL Server 6.5, you receive the following error message, and then Microsoft Access quits:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.



CAUSE
You tried to import an object that has a field name that is more than 64 characters long. Access projects do not support field names that have more than 64 characters.



RESOLUTION
To resolve this behavior, use 64 or fewer characters for your object names.



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
NOTE: The following steps assume that you can connect to the Pubs database with the default permissions. You may have to modify these steps to fit your security settings.
 * 1) Use Enterprise Manager to connect to the Pubs database on a SQL 7.0 server.
 * 2) Open the Authors table in Design view.
 * 3) Add au_lname to the Primary Key and modify the field name so that it has more than 64 characters.
 * 4) Save and then close the table.
 * 5) Open Access 2002.
 * 6) Create a new Access project using existing data. Name the project Adp1.adp.
 * 7) In the Data Link Properties dialog box, select your SQL 7.0 server.
 * 8) Verify that Use a specific user name and Password is selected, and then log on with username SA and no password.
 * 9) Under the third option in the Properties dialog box, make sure that Select the database on the server is selected, type pubs in the text box, and then click OK.
 * 10) Create a second Access project using existing data. Name this project Adp2.adp.
 * 11) In the Data Link Properties dialog box, select your SQL 6.5 server.
 * 12) Verify that Use a specific user name and Password is selected, and then log on with username SA and no password.
 * 13) Under the third option in the Properties dialog box, make sure that Select the database on the server is selected, type pubs in the text box, and then click OK.
 * 14) With the second Access project open, on the File menu, point to Get External Data, and then click Import.
 * 15) Browse to the location of the first Access project, select the file, and then click Import.
 * 16) When you are prompted, log on to the SQL 7.0 server.
 * 17) In the Import Objects dialog box, select the Authors table, and then click OK.

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

