Software·43,773 discussions

Access 200 Project – Recordset is not updateable

Locked

Hi,

I am a DBA and am trying to modify an Access 2000 Project made by someone else. Access forms file is on my pc while the database file is kept on server.

When I try to modify data in any table or form, I get error msg – “This recordset is not updateable”.

Whereas when I try to modify data in another database file after creating new forms and by exactly the same way & kept on that same server, I am able to do it!

Need urgent help on this. Waiting.

Vishal Sood

Topic

Reply To: Access 200 Project – Recordset is not updateable

In reply to Access 200 Project – Recordset is not updateable

There could be many things done with your database. But let us start eliminating the obvious. First open the database and check the user and group permissions via tools on the menu. Make sure that the objects (Tables) you want to update have the update permission checked. Secondly Ensure the table owner is you or admin and not the person who developed.

If it does not fix contact me again.

Reply To: Access 200 Project – Recordset is not updateable

In reply to Reply To: Access 200 Project – Recordset is not updateable

I have been able to solve the problem.

Issue actually lies with the primary key definition.

If a table is made with primary key, data is entered and then primary key is removed, access does not allow to modify / delete / insert new data & gives message that “Recordset is not updateable” !!

Hope it helps others too!

Chapter closed!:)

Reply To: Access 200 Project – Recordset is not updateable

In reply to Access 200 Project – Recordset is not updateable

This question was closed by the author

[Author]

Replies