MS Access Database Limitations

MS Access Database Limitations:

o Access database can be up to 2 GB in size.
o Access database doesn’t support more than 255 fields in a table. Only 255 fields are allowed in a table.
o Only 32 Indexes are allowed per table. (Indexes:- for retrieving or filtering the records faster)
o Only 10 fields are allowed in multiple field indexes and sum of fields length should not exceed 255 Bytes
o No limitation on the number of records in a table.
o A memo field can store up to 1 GB of characters.
o It can’t display a Memo larger than 64 KB in a form or datasheet.
o An ActiveX objects can be up to 2 GB in size.
o A row of the table should be lesser than 4 KB of size (exception for ActiveX and memo fields).
Above limitation is appliable to MS Access 2003 database.
I have gathered this information from various sources, hope this will be knowledgable for you.