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,424
    Provided Answers: 8
    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

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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
  •