ACC97: Changes to Design of Linked Table Saved If Data Modified

Last reviewed: April 17, 1997
Article ID: Q167068
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you make certain changes to the design of a linked table, the changes are saved, even though you are prompted with the following message:

   Microsoft Access can't save property changes for linked tables.

   Do you want to continue anyway?

CAUSE

Design changes to linked tables are saved if changes are also made to the data in the table, and the changes do not affect any of the following properties:

  • FieldSize
  • DefaultValue
  • ValidationRule
  • ValidationText
  • Required
  • AllowZeroLength

RESOLUTION

When prompted with the message "Microsoft Access can't save property changes for linked tables. Do you want to continue anyway?", click No. This will prevent you from making unwanted changes to the design of your tables.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open a new database and create a link to the Categories table in the sample database Northwind.mdb.

  2. Open the linked Categories table in Design view. Click Yes when prompted with the message "Table 'Categories' is a linked table. Some properties can't be modified. Do you want to open it anyway?".

  3. Change the Picture field data type to Text.

  4. On the View menu, click Datasheet.

  5. Click Yes when prompted with the message "You must first save the table. Do you want to save the table now?".

  6. Click Yes when prompted with the message "Microsoft Access can't save property changes for linked tables. Do you want to continue anyway?".

    Note that the table is opened in Datasheet view, and the Picture column has been changed to Text.

  7. Type a new record in the table. Close and save the table.

  8. Reopen the table. Note that the table has been modified with the new data type.

REFERENCES

For more information about linked table properties, search the Help Index for "linked tables, properties," or ask the Microsoft Access 97 Office Assistant.


Keywords : IsmIea kbusage
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.