Hi All
Some of you may "know me" and the DB project that I'm working on, but if you don't thats okay.
I have written COBOL programs interfacing with RDMS 30 years ago, but Access is total new me and I keep jumping into the deep end. I choose Access because it's free, I know Excel well, Like VBA, Its part of Office, and thought it could handle it okay. (I did know about that recursion problem/fix)
As I have worked though this project it appears to be bigger and deeper than I thought. (what else is new (Project Creep). Having made the decision that my Model is good enough, I have started to loading and writing some queries I'm finding that SQL requires a thought pattern that I have not got yet (I will soon or latter).
At this time The model has 2 hierarchical temporal (Command and Heritage), 1 Bill of Material (TOE), and generational Parent-Child (Lineage) relationships. I know that Access (jet) does NOT do recursion, I also know that VBA in can work around this problem (VBA in itself doesn't scary me).
My question to you guys is:
A) Switch the DB engine at this time, and to which one?
B) Work though this, everything else will be just as messy.
Attachment: An old ERD diagram of the project
Note: Table 29 is now 12 tables called the "E" tables (TOE)
5 major parts, A) Unit, B) Sources, C) Location, D) Historical persons (nothing yet) E) TOE