Change number of Columns from a max of 255 to 1000

[Pete]

Hi

How do i increase the columns in MSAccess from 255 to 1000 when runing a
query off two tables i need to merge? There are 525 columns I need to combine
into one table. I keep on getting an err 'Too many fields defined" (Error
3190)

Thanks
Pete

 

[Roger Carlson]

You don't. 255 is the maximum number of columns in a table or query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jerry Whittle]

Move all your stuff out to Excel 2007 as it can handle 1600 columns. Sounds
like you are using Access as a spreadsheet anyway.

 

[Eric Blitzer]

255 is the maximin number of columns in a table. If you need more than that
your databse structure not normalized. Break your tables up linking on a
unique key field.
For a complete list of Access specifications go to access help and type
"specicfications".