The record is not updateable

[jaryszek]

Hi,



i have query like this and when i am trying to insert manually ServerKind or Multiplier into t_Junction there is an error:

"The record is not updateable"

Why is that?



thank you,
Jacek Antek

[jaryszek]

Ok,

strange.

Problem exists even i have very simple query like this:


thank you for help,
Jacek

[jaryszek]

Ok Guys,

problem is BIG:



and it is occured when i have from one primary key a lot of tables.
Is there any workaround for this?

Best,
Jacek

[isladogs]

Have a look at this article on Allen Browne's site: http://allenbrowne.com/ser-61.html

[jaryszek]

Thank you ridders52,

still i have problem - i think any from the provided list is not matched here:

SELECT t_ServerInfo.Sockets, t_CpuOffer.Overhead, t_CpuInfo.Server
FROM (t_ServerInfo INNER JOIN t_CpuInfo ON t_ServerInfo.ServerInfo_ID = t_CpuInfo.ServerInfo_ID_FK) INNER JOIN t_CpuOffer ON t_ServerInfo.ServerInfo_ID = t_CpuOffer.ServerInfo_ID_FK;

What is wrong herE?

Best,
Jacek

[isladogs]

Using two one to many links likely to be the issue. Try joining two tables and save that.
then make a second query joining the first query and the other table

[CJ_London]

as Ridders says, queries with multiple tables are generally not updateable. You can try changing the dataset type (see query properties) to inconsistent updates, but updating tables directly in Access is an Excel mindset. Tables should be updated through forms, where the rule is one form, one table with joins represented by using subforms with the linkmaster/linkchild to represent the joins.