So I have this project on access 2003. I am trying to create a relation diagram of the tables. I have found this webpage of Microsoft: http://office.microsoft.com/en-us/access-help/create-a-database-diagram-adp-HP003085405.aspx but I do not see any Database diagram option as I was supposed to see according to that article.
I am not even sure what they meant by Diagram window (I can see the list of tables, forms, queries and so on in a window, is that what they meant?). I have worked with DB diagram in access 2007 and 2010 but 2003 seems to be totally different.
And another question: is there any restriction in creating diagram on front-end/back-end application?
The solution to this problem was fairly simple. I just had to double click on my mdb file then hold down the shift key. That made the options visible. The rest was easy.
Sorry my question might not be clear. I saw one answer but I think that is too advanced for me to even understand.