how do I amend data in linked access tables

[doctorwho]

I use access 2002. When I amend data in a table it does not copy the
amendment to the table it is linked to. Why is this? I have tried this with
several linked tables and with no success.

 

[Jeff Boyce]

I may not be understanding your use of the terms "amend" and "amendment"...

In Access, if you have a linked table, your ability to modify (?amend) data
in that table could depend on where that table actually lives. For example,
if it is in a SQL-Server database, you would need permission to edit values
in the table before Access could.

There is no "copy the amendment to the table" unless you are working in an
unbound form.

Please describe your situation more specifically for more specific
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

Not only that, but if you're accessing the data through ODBC (such as you
would be if the table is in SQL Server), the table must have a unique index.