how many fields are available in Access

[Daryl Baisley]

Is it still 256 or has Microsoft fixed this problem with
Access yet?

 

[TC]

It is not a "problem", at all.

Perhaps read this:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC

 

[John Vinson]

Is it still 256 or has Microsoft fixed this problem with
Access yet?

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.

 

[Douglas J. Steele]

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.

Of course, Excel only allows 256 columns...