Results 1 to 2 of 2
  1. #1
    jerill is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Nov 2011
    Posts
    8

    Unable to see relationship diagram in database after upsizing from Access 2003 to SQL

    Hi,
    I have upsized from Access 2003 to SQL Server 2008 R2 using upsizing wizard. Everything works fine. But I don't see relationship in SQL SErver 2008 R2 if I go to database. But I set relationship in Access 2003 before upsizing it.

    ALso I don't see relationship (diagram) in Access 2003 , which I was able to see before.



    So do I need to again recreate the relationship amongst the table in Access 2003 Or SQL SErver 2008 R2 ?
    Any idea ? I thought, if you link tables, everything should be taken care but i don't see relationship structure any more.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Sounds like an SQL, not Access, question.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unable to Read from COM ports in Access 2003
    By userThree in forum Programming
    Replies: 3
    Last Post: 07-31-2011, 08:59 PM
  2. Replies: 12
    Last Post: 06-16-2011, 01:35 PM
  3. Access database will not work in .Net 2003
    By Brilene in forum Access
    Replies: 0
    Last Post: 03-18-2011, 03:41 PM
  4. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 AM
  5. My Access Upsizing Nightmare...Opinions and Thoughts?
    By Jerimiah33 in forum Import/Export Data
    Replies: 0
    Last Post: 01-30-2007, 12:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums