I've been using ACCESS since 2014. I store Formulator PPs, result charts, an enormous amount of proprietary data, and an almost endless list of queries I use to help me handicap and study the data.
Eventually I started bumping up to the limits of its size capacity, but admittedly my initial database design was not very efficient. I was learning the product at the time. I'd design it differently if I stared over. You may do better.
What I do to get around the issue is pull out some of the data every 2 years and back it up to another database. For example, right now I have data for 2022 an 2021 in my main database, a backup with 2019 and 20020, a backup with 2017 and 2018 etc...
If I want to do long term studies (and I do) I can selectively add what I need from the backups, study it, then take it back out.
I was a computer programmer. I like the product. It's a bit clumsy at doing some things. So sometimes I export data to Excel, manipulate it in Excel, and then import it back to the database.
Several people here helped me a lot to get started. I can't remember everyone, but if I can find the original thread I'll post it.
__________________
"Unlearning is the highest form of learning"
Last edited by classhandicapper; 10-30-2022 at 03:32 PM.
|