Adding a new fields in a linked table

[swst]

I have an access table and i want to add a new field .

When I try to do this a message comes up.

"Table xxxxxx is a linked table with some properties that cannot be modified"

The field I want to add is a stand alone field within this table

Can any one help

Steve

 

[Gates Is Antichrist]

Depending on your Access version, either
right-click on the table, and click Linked Table Manager,
or go tools/database/Linked Table Manager,
or go tools/add-ins/Linked Table Manager

This will show where the table ACTUALLY is that you're accessing in your current database. To modify the structure you need to open the other database in Access first, and operate on it from there.