Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

mc access question

Options
  • 07-01-2010 4:20pm
    #1
    scarymoon1
    Closed Accounts Posts: 732 ✭✭✭


    i want to create an er diagram in ms access and when im trying to create the realtionships between the linking tables - it wont allow me to create a one to many relationship. I have not created the real database in ms access, i did that in phpmyadmin so maybe i have not created it right in ms access. The table i want to make the relationship to have 2 primary keys. Does anyone know of an easier way to create the er diagram. We can hand-draw it but i think it would look better done with some program. Any suggestions??? Thanks.


Comments

  • Options
    #2
    Tom Dunne
    Registered Users Posts: 23,212 ✭✭✭✭Tom Dunne


    scarymoon1 wrote: »
    Does anyone know of an easier way to create the er diagram.

    I am not aware of any way to create an ERD in MS Access (bar actually creating the database).

    Try Power Architect. It's free.


  • Options
    #3
    mark renton
    Closed Accounts Posts: 2,696 ✭✭✭mark renton


    or you could try Dia


  • Options
    #4
    HandWS LTD
    Closed Accounts Posts: 263 ✭✭HandWS LTD


    Its been a long time since i used relationships in ms access. There is a way you can do what you want. Have you tried right clicking the line between the relationships. If my memory serves me right, i think that was how it was done. It's been a few years so i cannot help you further. I may be wrong.


  • Options
    #5
    Webmonkey
    Registered Users Posts: 9,579 ✭✭✭Webmonkey


    john47832 wrote: »
    or you could try Dia
    +1 for dia. Quite useful


  • Options
    #6
    scarymoon1
    Closed Accounts Posts: 732 ✭✭✭scarymoon1


    just downloaded dia - cant get the hang of it. Ah il just hand-draw the er! thanks anyways for help :)


  • Advertisement
  • Options
    #7
    scarymoon1
    Closed Accounts Posts: 732 ✭✭✭scarymoon1


    Webmonkey wrote: »
    +1 for dia. Quite useful

    tried dia again - worked a treat. Thanks for suggesting it :)


  • Options
    #8
    mark renton
    Closed Accounts Posts: 2,696 ✭✭✭mark renton


    scarymoon1 wrote: »
    tried dia again - worked a treat. Thanks for suggesting it :)

    dont mention it


  • Options
    #9
    Webmonkey
    Registered Users Posts: 9,579 ✭✭✭Webmonkey


    john47832 wrote: »
    dont mention it
    Yep this is the man to thank :p


  • Options
    #10
    Naikon
    Closed Accounts Posts: 4,564 ✭✭✭Naikon


    Dia is great for drawing class/ER diagrams:)
    It has UML support built in, and can handle trivial
    drawings like network schematics.

    Good tool for documentation, without the extra overhead
    associated with monster tools like Rational Rose or ERwin.
    Not as featured as the above though much, much smaller.


Advertisement