Recordset is not updatable

hyousef

Registered User.
Local time
Today, 19:12
Joined
Jan 15, 2002
Messages
41
I have a query consists of 3 tables and one crossReference table. I built a form that display my query but the problem is I can't update and insert data in my fields and i can't add new record...It says that "This recordset is not updatable". Any help is appreciated. Thanks.
 
I would imagine that there is either a problem with your table relationships or the relationship between the tables that you have set up in the query.

From Access Help:

Query based on three or more tables in which there is a many-to-one-to-many relationship.
Updatable: No
Though you can't update the data in the query directly, you can update the data in a form or data access page based on the query if the form's RecordsetType property is set to Dynaset (Inconsistent Updates).

Search for Inconsistent Updates in Access Help.

[This message has been edited by DBL (edited 02-23-2002).]
 
Thanks i set RecordsetType property to Dynaset (Inconsistent Updates)and it works.
redface.gif
)
 

Users who are viewing this thread

Back
Top Bottom