Software

General discussion

Gravatar
0 Votes
Locked

Access 200 Project - Recordset is not updateable

By vishalsood007 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by clesafe In reply to Access 200 Project - Reco ...

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.

gravatar
Collapse -

by vishalsood007 In reply to

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!:)

gravatar
Collapse -

by vishalsood007 In reply to Access 200 Project - Reco ...

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums