I am building an Access 2010 database that will hold the input data for different scenarios. I will be using another program that reads the data from the database. but I need to ensure it only reads data for a specified scenario.
I am considering how best to achive this and would appreciate advice.
Should I set up a backend database that holds the data from all scenarios and a frontend database that retrieves the data for a scenario based on a scenario ID within the backend database?
Is this a good approach or would you suggest another approach?