Run time error 3326

Thegorsk8758

New Member
Joined
Jun 11, 2009
Messages
7
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Forum statistics

Threads
1,089,167
Messages
5,406,577
Members
403,097
Latest member
danielcarrington

This Week's Hot Topics

Top