"too many crosstab column headers" error - IN DESIGN VIEW!@!?!?!?

[Bob]

running access 2k;

I have a query that uses a crosstab query as one of the tables in this
query.
I cannot even open this query in DESIGN view without getting the too
many xtab header error!?!?!

how the bloody you know what could I possibly get an error like this
while trying to open a query in design mode?!?!?

FORGET the fact, that the xtab query absolutely does NOT exceed 255
columns!!!!

TIA - Bob

 

[Allen Browne]

Bob, it sounds like something has gone wrong with this query, so here's a
way to try to rescue it:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

3. Open the Immediate Window (Ctrl+G), and enter:
? CurrentDb.QueryDefs("Query1").SQL
substituting the name of your query for Query1.
Access should print the entire SQL statement in the Immediate window. Copy
it to clipboard.

4. Create a new query. Design view.
Cancel the Add Table dialog.
Switch to SQL View (View menu.)
Paste the SQL statement in.

5. After checking there's nothing obvious wrong with the SQL statement (such
as too many items in the IN part of the PIVOT clause), switch to design
view.

 

[Bob]

Allen;

Tx for your reply.... I've already done some of your suggestions
before my original post, but I will try the rest & see what happens...

TX!