Knowledge Base

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

Article ID: 167068

Article Last Modified on 1/19/2007

Microsoft Access 97 Standard Edition

This article was previously published under Q167068

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

SYMPTOMS

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

Open a new database and create a link to the Categories table in the sample database Northwind.mdb.
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?".
Change the Picture field data type to Text.
On the View menu, click Datasheet.
Click Yes when prompted with the message "You must first save the table. Do you want to save the table now?".
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.
Type a new record in the table. Close and save the table.
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: kbprb kbusage KB167068