ACC: Operation Stops When Editing Attached SQL Tables (96897)

RESOLUTION

1. Remove the index from any fields with the Date/Time or Float data types.
   
   To obtain information on any index within a SQL table, you can run the following system stored procedure within the System Administrator Facility (SAF):
   

   sp_helpindex <Table Name>

   
   To remove an index, use the following command:
   

   DROP INDEX <Table_Name.Index_Name>

   
   Note that you must be logged into the SQL Server as either the table owner or the System Administrator.
2. If other fields in the table have the Float data type, you must insert a TimeStamp field in the table. If a field with this data type is present, Microsoft Access returns a consistent value for fields of this data type and will use the value in this field to verify whether the record has been modified.
   
   This can be accomplished by performing the following command within SAF:
   

   ALTER TABLE <Table Name> ADD TimeStamp timestamp

   
   Note that you must be logged in as either the database owner or the System Administrator to run this command.

NOTE: If the Timestamp field is added to an existing table with existing data it will have a null value for the existing data and therefore the problem will still occur on operations to that existing data. New data added with a Timestamp being created will be fine. It is better to create the table from scratch and copy the data over.