Hi,
I'm in the early stages of building a program based on Access db.
It will store a daily data retrieved from bank accounts.
My main issue is how to design it since the amount of data is vast and it will fill up the DB's size limit within a month or so.
I will have to save the data because I will need to compare data from different months.
I thought of creating a new DB for every month, but how will I be able to compare data between month in that way?
I can't use SQL Server because of different reasons and I'm not familiar with other DB's.
Any ideas?
Thanks!