I've sorted the chaotic data model a little bit in the attachment. You should always try to create a data model without crossing lines as good as possible, makes it more readable.
Although your model looks a little bit better now I would say there are significant errors in the relations because multiple tables are linked together on multiple ways which mostly is not needed. But I cannot say more because I really cannot see what the target or sense of this database should be.
Moreover I think it would get far away from your initial question to discuss your data model in this thread.
For your other questions about the background of what is saved in pages I think Jim can answer that better than me.
multiple tables are linked together on multiple ways which mostly is not needed? which tables in the attached database are we talking about and what are some fixes for that?
|Authenticate Username & Password from MS Access to Active Directory||5||45|
|Close Print Preview button not active||12||35|
|MS Access MSXML2 DomDocument.Load and XMLHTTP.Send Not Sending utf-8 Char Format Correctly||3||40|
|Run-time error 429 - ActiveX Component Can't Create Object - VBA Code - MS Access - Adobe||4||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!