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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-11-16 : 10:34:40
|
| Good Morning, everybody.I was asked to help our power users to figure out why they cannot edit their data. This is a sql 2000 database created by an outside vendor for their department. They have added some tables to it, and now want to use the linked tables from MS Access to modify the data.They used machine ODBC DSN with integrated authentication to link the tables. On the table’s property window, I have checked select/insert/update/delete for all the users and roles on the server, and re-linked them, but the problem still there. The design of these tables is simple. Nothing in the create statement seems could cause this problem.Where else should I look for?Thanks!Hommer |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-16 : 23:16:02
|
| can they directly update a record in the table using query analyzer or enterprise manager?--------------------keeping it simple... |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-16 : 23:52:04
|
| The tables have to contain a primary key on the SQL Server side or MS Access will not allow you to edit the data.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-11-17 : 10:27:34
|
| Thank you Derrick and Jen.Adding a PK solved my problem. |
|
|
|
|
|
|
rights to edit