Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-11-2017, 10:50 PM   #1
safeerbinsalih
Newly Registered User
 
Join Date: Dec 2015
Posts: 26
Thanks: 7
Thanked 0 Times in 0 Posts
safeerbinsalih is on a distinguished road
Unhappy Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

My database was working properly until yesterday. A new error is throwing while opening a form

Run-time error '-2147352567 (800200009)' :
This Recordset is not updateable

I'm not able to update the data in linked table using this form. however I'm able to change the data directly going into the table.

Any help is really appreciated.

safeerbinsalih is offline   Reply With Quote
Old 04-12-2017, 12:23 AM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

If it was working before and you didn't change anything, try a Compact and Repair, else create a new database and import all into it.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 04-12-2017, 12:56 AM   #3
safeerbinsalih
Newly Registered User
 
Join Date: Dec 2015
Posts: 26
Thanks: 7
Thanked 0 Times in 0 Posts
safeerbinsalih is on a distinguished road
Re: Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

Tried both. But not working.

safeerbinsalih is offline   Reply With Quote
Old 04-12-2017, 01:04 AM   #4
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

Okay.
Then something has changed, when the database doesn't got corrupt, it can't work one day and not another day.
Post you database with some sample data, + tell how to reproduce the error.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
safeerbinsalih (04-12-2017)
Old 04-12-2017, 01:19 AM   #5
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

Quote:
Originally Posted by safeerbinsalih View Post
...
Run-time error '-2147352567 (800200009)' :
This Recordset is not updateable

I'm not able to update the data in linked table using this form. however I'm able to change the data directly going into the table.
I sound more that the recordsource for the form, is a query as a table.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 04-12-2017, 03:36 AM   #6
safeerbinsalih
Newly Registered User
 
Join Date: Dec 2015
Posts: 26
Thanks: 7
Thanked 0 Times in 0 Posts
safeerbinsalih is on a distinguished road
Re: Run-time error '-2147352567 (800200009)' : This Recordset is not updateable

I copied and replaced the table. Now it is working. Don't know how. But, thanks for your support JHB.

safeerbinsalih is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time Error '-2147352567 (80020009)' The value you entered isn't valid for this fi DanielBry Modules & VBA 22 07-31-2016 09:59 AM
Run-time Error '-2147352567 (80020009)' When I Select 1st Record In Subform, Access 2 skoolz Modules & VBA 2 07-18-2015 06:07 PM
Run-time error '-2147352567 (80020009)': This Recordset is not updateable. slaterino Forms 3 05-07-2009 03:10 PM
Upgrading from 2000 to 2003 - Run-time error -2147352567 johndoomed Modules & VBA 5 07-30-2007 02:50 AM
Runtime error -2147352567 (800200009) vmon Modules & VBA 2 03-13-2003 01:29 PM




All times are GMT -8. The time now is 03:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World