Database design question

[udigold1]

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!

[RayMilhon]

Given your requirements there's only one way. Create your front end Access DB with all of your forms, reports, queries. Then build your monthly Databases Each month and use your front end to link to the table in each backend.

[udigold1]

Thanks,

And with if I want a C# WinForms app to be my front end and not forms on access?

[RayMilhon]

Sorry someone else will have to help from here. I've never used C#