Can not update/add or edit records on database

[Rahel]

I have a client with relevant permissions to access a database based on NT security. Every possible permission has been granted to the client (NT Login Account)for the database and database objects. <br><br>My client can login and see tables and views, however cannot update or edit any records. I am connecting via ODBC and I have run out of ideas.<br><br>Has anyone encountered this problem or can suggest a course of action to try to remedy this problem. <br><br>

 

[BootMeUp]

Is the NT account on the client machine the same as the SQL/NT user in the dbms?&nbsp;&nbsp;ODBC will use account logged on to client machine - which may have only select permissions.&lt;P&gt;<br>Other thing to check to see if client logged on to client machine, is same as &quot;login&quot; on dbms. (The SQL logon account should be an NT acct, not SQL acct). &lt;P&gt;<br>Steve A.

 

[Invicta]

Rahel, when you say your client can &quot;see&quot; tables do you mean that you can see that the tables are there or do you mean that you can see the data within the tables?