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.
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.
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" !!
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 200 Project - Recordset is not updateable
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