How many fields can you have in an access 2007 database

F

forest8

Hi

I have imported an excel file into Access 2007. When I try to add another
field, it tells me I have exceeded the maximum number of columns of 255.

I thought there was no issue in Access 2007 in the number of fields allowed.

Please advise.

Thank you for your help in advance.
 
L

Lynn Trapp

If you need that many fields in a single table, then there is something
wrong with the design of your database. The largest number of fields, in a
single table, I recall seeing in a well designed and properly normalized
database is around 65, and that was an Oracle Applications database table.

Can you describe what you are trying to do and what kind of data you are
trying to store?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Whats the maximum number of rows Access 2007 can take? 3
Number Fields in Access 2007 Database 1
Access Table - Maximun Number of Fields? 4
More than 255 Fields in a Table 17
Access Access 2003 - max fields in table error 2
Some Access 2007 questions 3
Too many fields 3
OPENING ACCESS 2007 DATABASE IN ACCESS 2003 8

Top