Recordset not updateable

[pl456]

I have a query based on 2 pretty simple tables, I am doing nothing fancy with it just selecting the data. The query executes fine but will not allow me to update the data.

Not sure what i am doing wrong here and have looked at all the reason MS give for this state and can find no reason why.

Has anybody got any ideas? Running access 2007.

 

[MSAccessRookie]

I have a query based on 2 pretty simple tables, I am doing nothing fancy with it just selecting the data. The query executes fine but will not allow me to update the data.

Not sure what i am doing wrong here and have looked at all the reason MS give for this state and can find no reason why.

Has anybody got any ideas? Running access 2007.

It is easiest for us to make an assessment when we can see the queries that are involved. In the mean time, check the following:

1. Does the query include all of the required fields from the table? If it does not, then it could wind up being Read Only.
2. Does the query contain any calculated fields? This could make it Read Only as well.
3. Is the query based on an SQL Server or other Non-Access View (Probably not, but just checking al bases)? This could make it Read Only as well.

Post the SQL code if none of these suggestions works, and we can try to assist you.

 

[pl456]

Heres the sql

SELECT data1.*, teams.*
FROM teams INNER JOIN data1 ON teams.codeno = data1.codeno;

 

[neileg]

Is codeno the PK in one of the tables or otherwise unique? If not, you will get a many to many join and this will be non-updateable

 

[pl456]

Thought it was but obviously it was not. That is the answer thankyou.