Read Only Table

[ryansdv]

hi everybody,

its my first time with access2k project. i'm connected to "ms sql 2000 developer edition" with a "system admin" rights. im so certain that i have all the authority to select, insert, update and delete.

my question is, why in ms access2k project (located in workstation, only one access project is running), some tables are read only and some are not? why it doesn't follow the set rights in the server.

hoping for help.

 

[OnTheFly]

The permissions are set on the SQL server based on your user and the role it is assigned to. Each table is given permissions individually through SQL within the database. If you have set the permissions then I am not sure where to suggest looking but it is worth checking them again.

Hope this helps.

OnTheFly

 

[Suziii]

Check if you have primary key for every table. If not, you are not able to insert / update that table.