Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


"This Recordset is not Updatable", how to make it updatable

Posted on 2007-08-09
Medium Priority
Last Modified: 2013-12-05
I am trying to update data in an SQL Server 2000 database via Access 2000 set up as an ADP.  I get the error "This Recordset is not updatable" even though all permissions have been given in the database at the database, table, and column level.  I don't see anything in the Access settings that should prevent this from working.

Help, Thanks
Question by:dougbroadwell
1 Comment
LVL 19

Accepted Solution

Limbeck earned 2000 total points
ID: 19664667

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question