I have to start bulding an access database with time series data of ewquity securities starting from 1980. I have to store about 60 fields for 5000-6000 securities from 1980 till date on a quarterly basis( 4 dates/year) . I can break the fields into 5-6 logical tables and connect them using the security ID.
This data amounts to be about 11 million records split across ifferent tables and will grow each quarter with 200000 records.
I am not sure if I will breach the size limits with this ? should I build this in access or sql?? One solution i was thinkin was to split the db into 2.
Please help.