how do I amend data in linked access tables

  • Thread starter Thread starter doctorwho
  • Start date Start date
D

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.
 
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
 
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.
 
Back
Top