Problem editing or updating database from client machine

[Rahel]

I have a problem enabling a client to write, edit and make updates to a database. The client has full permissions to edit and update the database. When trying to edit a record a message comes up saying this recordset is not updateable.<br><br>The client is able to access and view the relevant tables in the database he has permissions for via NT Security. I have a 5 client access liscense for SQL Server 7.0 and the server machine has been setup as a standalone server.<br><br>The default language is 'English', the default database is 'Master' for my clients login and has access granted for the database he wants to update.<br><br>Can anyone suggest a course of action to try.

 

[cdukes]

It sounds as though you are trying to update a recordset not the actual database (slight difference). What are you using to create the recordset ADO, RDO or DAO and how are you creating it? You are probably creating a recordset that is not updatable. If using ADO, check the CursorType, CursorLocation, LockType Etc. All will affect whether you are allowed to edit / Update records in the recordset. <br><br>Note also, it is not advisable to default a user database to 'master', but to default the database to the database they intend to use.<br><br>Hope this helps,<br><br>Chris Dukes

 

[gummadi]

Hi<br><br>Check if your are upadating primary key column referenced in other tables<br><br><br>Gummadi