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.
Recordset is not updatable
- Thread starter hyousef
- Start date
DBL
Registered User.
- Local time
- Today, 08:52
- Joined
- Feb 20, 2002
- Messages
- 659
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).]
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).]
