We have a database in MS Access. This DB has over 100 tables and lots of views. This DBs' apps is about to go thru some required changes by users.
For what we need to do, the DB hasn't direct table relationship within it's structure (by this we mean a lot of child tables has no parent id being referenced) to produce the result required.
We decided to create views.
Our main concerne is the DB current structure and what impact will addtional views implies? We don't want the application to be affected by the modification so the report is created in a new apps and will be linked by clic from main apps. The o ly modification that's going to be done are new views.