Fields in a table (1 Viewer)

[RonR]

how many fields can be entered into a table?

I have Access 2003

 

[KeithG]

256 total fields in a table

 

[boblarson]

If you go to the main help file and type Access Specification and then enter you will get all of that good info. But the fields in a table are 255, and it would be rare, if you had to use that many. It is possible to have a normalized database and need more fields than that, or even over 100, but it is very rare and should be looked at very carefully to make sure that the design is proper.

 

[RonR]

ok, that is what I thought.

I copied a table from an Access 97 Db into a Access 2003 Db and it acted funny, it said I had too many tables but i only had maybe 100 or so.

thanks!!!


I really needed the info!!

 

[boblarson]

it said I had too many tables but i only had maybe 100 or so.

A message of "Too many tables" is different than too many fields.

 

[KeithG]

try doing a compact and repair

 

[RonR]

sorry, I meant to say fields.

 

[RonR]

I do not want to convert the Access 97 to a Access 2003.

I want to start out with a fresh database.


thanks for the tip tho.

 

[boblarson]

256 total fields in a table

One off - it is 255, not 256.

 

[RonR]

ok, I thought it was a lot more than I had entered.

I figured the answer was one off.

 

[KeithG]

One off - it is 255, not 256.

OOps! I was close but I guess that only counts in horse shoe's and hand generandes.

 

[boblarson]

OOps! I was close but I guess that only counts in horse shoe's and hand generandes.

Keith:

I think you're allowed to be off slightly, every once in a while. But, if it starts to become a habit, we're going to have to relegate you to the Watercooler.