ACC2000: Exporting to SQL Server Does Not Create Indexes (209797)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209797
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

Microsoft Access allows you to export data to a SQL Server back-end database. However, Access does not build the index on export. This may create potential problems and confusion. For example, if you then link the table, updates are not allowed and the data is displayed as read-only in Datasheet or Form view.

RESOLUTION

When linking to a SQL Server table that has no unique index, you are asked to create a unique index on the linked table. This choice is optional.

NOTE: If you select a field or fields that do not have unique values, this is not detected until you try updating a record and are prevented from doing so. At that time, you may delete the link and re-link the SQL Server table, specifying a different field or fields for the unique index.

REFERENCES

For more information about updating linked tables, click Microsoft Access Help on the Help menu, type linked table in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.


For more information about creating indexes on SQL Server database tables, see the SQL Server "System Administrator's Guide," in SQL Server Books Online.
Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbprb kbusage KB209797
©2004 Microsoft Corporation. All rights reserved.