Microsoft KB Archive/209797

= ACC2000: Exporting to SQL Server Does Not Create Indexes =

Article ID: 209797

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

