Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Unanswered: Microsoft SQL / Access linking

    My IT department has converted an existing Sybase datawarehouse to Microsoft SQL & when I attempt to link the tables into a Microsoft Access reporting database I lose all of the Primary Keys. Has anyone encountered & or solved this problem? Any assistance would be much appreciated.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    did IT department set up the Primary keys in the SQL database

    (When I upgrade a mmsaccess 97 to SQL the Primary key were not keep had to Manually do all that a LONNNNNNNNNNNNNNGGGGGGGGG Job)
    how are you trying to connect to the SQL by ODBC ???
    Last edited by myle; 06-27-10 at 21:46. Reason: spelling
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jun 2010
    Posts
    2

    That is what I feared

    Thanks myle. That was the answer I was expecting, typical of Microsoft to take something that was working fine in Sybase, make it proprietary & break it.

    Confirmation much appreciated
    FB@TVSN

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You've got the right idea, but you've got it backwards.

    DRI is standard SQL, the inferred primary keys that MS-Access derives from the Sybase indicies are proprietary. Because Microsoft SQL does support the standard DRI, MS-Access doesn't infer the proprietary keys.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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