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

 

[J_Goddard via AccessMonster.com]

Hi -

I am not clear on exactly what your problem is. When do you get this error?
It should not be as a result of the wizard, but - does one of the fields in
your source table have that display Format for it? If so, see if removing it
and running the wizard again solves the problem. It's a bit of a shot in the
dark, I know, but it's the only way that I can see that the crosstab wizard
would encounter a Format.

What do you mean by "the structure mask" of the query? Can't you just open
the query in design view?

HTH

John

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.