ACC2000: Exporting to SQL Server Does Not Create Indexes

ID: Q209797

The information in this article applies to:
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.

Additional query words: odbc prb attach attached 


Keywords          : kbusage kbdta ObcSqlms OdbcOthr 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999