Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Auric
Yak Posting Veteran
70 Posts |
 Posted - 2004-11-08 : 18:33:23
|
| HelloI have two tables linked via MS SQL to an Access frontend. For Some reason I cannot add/remove/modify anything in one table, the permissions are set and I am connecting using the sa account. any ideas. Josh |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-08 : 21:52:45
|
| If the SQL Server table does not have a primary key or unique index on it, and you didn't specify a unique set of columns when you linked it to Access, then it will not allow you to make changes to the data because it cannot identify which row(s) to modify. This can also be a problem if you linked to a SQL Server view instead of a table.Add a primary key to the table in SQL Server, delete the link in Access and re-link it, and you should be fine. |
 |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2004-11-08 : 22:39:32
|
| Thanks Rob! Sorry for the Cross-Post |
|
|
|
|
|
|
Unable to add/delete to SQL Linked Table?