Recorset not updateable in a crosstab query

[michelangelo]

I have created a crosstab query based on just one linked table using the
Access wizard and when I finished I get the erro "The recorset is not
updateable", clicking on OK it shows me the tahe results in the corresponding
table, but if I try to see the structure of the query it shows me the
structure mask but saying that in the expression "Format([DPC]:"aaaa")" there
to many closing brackets.

I copied the table to the current DB to avoid any links problems but the
result is the same.

Can anybody tell me how to solve the problem?

Thanks very much in advance

Michelangelo

 

[Jerry Whittle]

Crosstabs will be "not updateable" so you won't be able to use it to change
or add records. Still I don't know why you are getting that error when
creating it. How is the table linked? ODBC?

Are you trying to view the query in the normal design view or SQL View? SQL
view is the way to go. In fact go to SQL view and copy and paste the SQL here
so we can better see what is going on.