How can I use Access to edit SQL tables?

[dantebothermy]

(This thread should supercede my most recent question.)

I have tables on a SQL Server database; the tables are linked (as linked tables) to an Access database.

Access will not let me edit the data or add new records on the remote tables.

Anyone have advice?

Thanks,


Dante

[Delerna]

When you link tables in access you may be asked to indicate the fields that provide a unique key.
If you did not do that then there is no unique key setup and you will not be able to add or edit records in the linked table.

If this is the case then either
1) Design the tables and identify the appropriate keys, on SQL server.
Then re-link the tables in access.
This is the better option because appropriate keys are a critical part of good database design. As a bonus, access will not ask you to identify the key fields because they are already there

or

2) Re-link the tables and select the primary keys when access asks you to identify them.

[NeoPa]

Alternatively, the security on your SQL Server may not be set up to allow modification. It's entirely possible you have been given R/O access only.

How do you identify yourself to the SQL Server?