DBApprentice
On Error GoTo AWF *****:
- Local time
- Today, 12:21
- Joined
- Dec 24, 2018
- Messages
- 150
Hellos Masters!
I am here again evoking your wisdom!
How can I calculate the capacity Access has to handle records in a database?
I have seem some people saying it has up to 2gb per table, but it looses Relational Integrity in some cases.
Specifically in my case, I am learning DB Design and following Hernandez DB Design Process and I came to 17 tables, they will hold a total of approximattely 85 fields and I have set them to the number of characters in case of texts and some are long text fields. The Audit Trail and User Activity tables are set to have replication ID. I am building this to last at least 10 years receiving up to 300 records per day (Will hold at least 1.095.000 records) give or take.
How can I know for sure how to correctly calculate the space this could take in Access and if it could handle that amount of records before going for archiving or sanitizing records?
I am here again evoking your wisdom!
How can I calculate the capacity Access has to handle records in a database?
I have seem some people saying it has up to 2gb per table, but it looses Relational Integrity in some cases.
Specifically in my case, I am learning DB Design and following Hernandez DB Design Process and I came to 17 tables, they will hold a total of approximattely 85 fields and I have set them to the number of characters in case of texts and some are long text fields. The Audit Trail and User Activity tables are set to have replication ID. I am building this to last at least 10 years receiving up to 300 records per day (Will hold at least 1.095.000 records) give or take.
How can I know for sure how to correctly calculate the space this could take in Access and if it could handle that amount of records before going for archiving or sanitizing records?