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

safeerbinsalih

Registered User.
Local time
Today, 13:15
Joined
Dec 30, 2015
Messages
26
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.
 

JHB

Have been here a while
Local time
Today, 08:45
Joined
Jun 17, 2012
Messages
7,720
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.
 

safeerbinsalih

Registered User.
Local time
Today, 13:15
Joined
Dec 30, 2015
Messages
26
Tried both. But not working. :(
 

JHB

Have been here a while
Local time
Today, 08:45
Joined
Jun 17, 2012
Messages
7,720
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.
 

JHB

Have been here a while
Local time
Today, 08:45
Joined
Jun 17, 2012
Messages
7,720
...
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.
 

safeerbinsalih

Registered User.
Local time
Today, 13:15
Joined
Dec 30, 2015
Messages
26
I copied and replaced the table. Now it is working. Don't know how. But, thanks for your support JHB.
 

Users who are viewing this thread

Top Bottom