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 |
|
naushi
Starting Member
10 Posts |
 Posted - 2009-03-17 : 13:25:31
|
| we just migrated a database from sql2000 to sql 2005. the front end is Access and user uses the database with linked tables. the user has db_reader and db-writer permission but cant update tables. We enhanced the privilege to db-owner but they still cant update the table. He can update one table with PK but not the one with no PK. most web site articles stress on having a PK. But the user cannot change its structure. What can we do so user can update the table. any help will be appreicatednaushi hussain |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-17 : 13:33:26
|
| how are you trying to update? using grid in sql mgmnt or using t-sql update statement? |
 |
|
|
naushi
Starting Member
10 Posts |
Posted - 2009-03-17 : 13:55:20
|
| user opens the table in Access (as a grid) and is trying to change the data by clicking on the column and inputing the new amount over the old onenaushi hussain |
|
|
|
|
|
|
table is not updateable