Database Design Question - A Lot Of Fields Or A Lot Of Tables?

[dbeeLee]

I'd also like to point out that an Access database has a 2GB file size limit, and 255 fields per table. You can not have 1300 fields in a single table. Total objects allowed in the database is 32,768. Microsoft Access is the wrong solution for your requirements. You need to use something else.

https://support.microsoft.com/en-us/...more%20rows%20

[lauryfriese]

I'd also like to point out that an Access database has a 2GB file size limit, and 255 fields per table. You can not have 1300 fields in a single table. Total objects allowed in the database is 32,768. Microsoft Access is the wrong solution for your requirements. You need to use something else.

https://support.microsoft.com/en-us/...more%20rows%20 Candy Crush

Thanks a lot.