Querry is read only

[Guest]

Hi-
Just a quick question - I have a simple querry that is the combination of 4
tables - for some reason it is coming up as read only... any idea what would
cause that?

thanks for your help-

 

[Duane Hookom]

Are any of the joins based on fields where one side is not a primary key?

 

[Guest]

Yes - is that the problem??

Are any of the joins based on fields where one side is not a primary key?

 

[Duane Hookom]

Very likely the problem is the links with non-primary key fields. Try remove
a table that doesn't involve a primary key and see if the query is editable.