Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049

    Unanswered: Upgrade from 2000 to 2005 Express made my diagram inaccessible...

    Hi all

    I have a database that has been working sweetly for over a year, an Access front end with an SQL Server 2000 back end. No problems.

    Then the IT trolls came along and "upgraded" the SQL Server to 2005 Express. Sounds good, but prior to the update I had an ERD (Diagram). Now I'm no SQL Guru, so I rely on the diagram to create relationships and for referencing while coding.

    The SQL Server 2005 Express version holds the tables and everything ok, but there is no diagram and I read up in help and find that the diagrams are incompatible. I read that I have to somehow update it to "2005 compatibility". When I use the interface I find a compatibility option which has SQL Server 7 and SQL Server 2000, but not SQL Server 2005. I'm now kinda stuck.

    How can I recover the ERD diagram or at least be able to create a new one in 2005 Express??

    Thank in advance for any advice

    If you need any further information, please ask!

    Cheers

    ST
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Bump.... No ideas??
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why not use the 2000 Enterprise Manager tool on the other machine? ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Hey wow, that's a great idea! Thanks!

    lol
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •