MICROSOFT ACCESS
If I add a field in a table it gives an error:
"Too many fields defined"
I have many fields in the table but I don't think it's a limitation of Access. I know that I can define up to 255 fields. Is it true?
Printable View
MICROSOFT ACCESS
If I add a field in a table it gives an error:
"Too many fields defined"
I have many fields in the table but I don't think it's a limitation of Access. I know that I can define up to 255 fields. Is it true?
This Question is not related to the CR :)
Read
Yes you are correct
The data component of an Access database are the tables. Tables are like spreadsheets where each row is a data record and each column is a distinct field or data feature. The maximum number of fields in a single table is 255. One can include 32,768 tables in a single database .mdb file.