ACC2002: Error Importing Table into Access Project Connected to SQL Server 6.5 (295205)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

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 "Symptoms" section of this article.

REFERENCES

For more information about Access project specifications, click Microsoft Access Help on the Help menu, type specifications in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kberrmsg KB295205
©2003 Microsoft Corporation. All rights reserved.