Software

Ask something
Discussion Locked

Access 2000 exceeds maximum #columns

0 helpful
3 replies

by jr_oneputt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
working on a data base and keep coming up with the same message "exceeds maximum number of columns. The database has combined the last 2 columns into one, making it difficult to deal with the info. Is there a set #columns in access or is there some way to change the maximum # of columns?

3 replies

by bristar

There is a limit of 255 fields in either a table or a query. Is there any way you can split the table and rejoin necessary data using a primary key?

This discussion is closed to new replies.