how many fields are available in Access

  • Thread starter Thread starter Daryl Baisley
  • Start date Start date
Is it still 256 or has Microsoft fixed this problem with
Access yet?
Click to expand...

255. And it's not a problem if you design databases using relational
principles; I've needed as many as 60 fields, twice in the past twenty
years, and I've built a tidy few databases.

If you want a spreadsheet rather than a relational database, consider
using Excel.
 
John Vinson said:
255. And it's not a problem if you design databases using relational
principles; I've needed as many as 60 fields, twice in the past twenty
years, and I've built a tidy few databases.

If you want a spreadsheet rather than a relational database, consider
using Excel.
Click to expand...

Of course, Excel only allows 256 columns...
 
Back
Top