Take the 2-minute tour ×  I'm in the early stages of building a
winform C# app based on Access db (can't use other types of DB
for different reasons). My main issue is how to design the DB
since the amount of data is vast (based on daily data) and it
will fill up the its size limit within a month or so. I thought
of creating a new DB for every month, but how will I be able to
compare data between the different DB, for example, between
months? I want the C# app to execute the queries. Are there any
tutorials, books? I have no experience of using and linking
front and back-end Access.  Any ideas? Thanks!  share|improve
this question What is this size limit? If you are worried about
reaching this limit, perhaps you should reconsider using Access
for a database. –  Bernard Mar 22 '12 at 17:58 Sounds like he's
stuck with Access. :( –  Almo Mar 22 '12 at 17:59 I second
Bernard's comment. You are trying to solve a scaling problem
when you know the solution cannot scale. –  Bryan Crosby Mar 22
'12 at 18:02 What are t