How many fields does the new Access 2002 have?

  • Thread starter Thread starter Guest
  • Start date Start date
i am looking for 8000 to 10000. Thank you
Click to expand...

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!
 
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.
 
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.
 
Back
Top