How many fields does the new Access 2002 have?

[Guest]

i am looking for 8000 to 10000. Thank you

 

[John Vinson]

i am looking for 8000 to 10000. Thank you

255, same as all other versions of Access.

I have needed as many as 60 fields in a table, maybe twice in the past
twenty years of database design work. NO relational table could ever
POSSIBLY need 10000 fields. "Fields are expensive, records are cheap"
- if you turn your problem sideways, and think of tall-thin tables
rather than one monstrously wide table, you'll find things a LOT
easier.

What kind of data are you storing? Have you studied the concepts of
"normalization"? If not, now's a good time to start!

 

[Cheryl Fischer]

Open Access Help and then navigate to the Getting Started topic, then the
Microsoft Access Specifications sub-topic. You will find that:

The maximum size of an Access 2002 database cannot exceed 2 GB.
The maximum number of objects in an Access 2002 database is 32768
The maximum number of fields in a table is 255.

Additional specifications are also listed in this topic.

 

[Joseph Meehan]

Me thinks you have a real problem with 8,000 fields. I can't think of a
need for anything like that other than poor table design.

Why do you need so many. Maybe we can give you some suggestions.