Run time error 3326

[Thegorsk8758]

Hey All,

I am getting a run-time error that says the record set is not update able. I have read around it is a problem with my query and my form interacting. Brief overview of the database:

Tables:
Issues: ID, Title, Description, Assigned to, Opened by, Project
Contacts: CID, First Name, Last Name, Phone Number
Project: Project (Projects Name), Active Project

Issues Assigned to and Opened by fields are related to the CID and the issues.project is related to the project.project

The SQL runs fine and I can get the data, but I cannot get the form to load all it says is that the record set is not update able.

Any help would be greatly appreciated

 

[SydneyGeek]

Is Project.Project a primary key?

When you relate 2 or more tables in a query, at least one side of each join must be a primary key or Access will not be able to handle edits correctly, and the query will be read-only.

If it is a primary key, you need to play with the fields in the query to get an editable recordset (you can tell by opening the query; if the New record icon is greyed out, the query is not editable). For example, any field directly involved in a join can be pulled from either of two tables. Set both to pull from the "central" table; if that works, you're in business. If not, switch both fields to pull from the "flanking" tables.

If still no good, check that none of the data sources involves a non-editable query.

The following query types are always non-updateable;
Crosstab
Totals
DISTINCT
UNION
Pass-Through
Action queries (Make-table, Append, Update, Delete)

In addition, many queries that use sub queries are not editable.

Denis