Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 97 linking tables from Sql server 2000

Discussion in 'Information Technology' started by Domac, Jul 28, 2006.

  1. Domac

    Domac
    Expand Collapse
    Guest

    Hi,

    Can I link tables from SQL Server 2000 into Access 97???


    Thanks!
    Domac
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Sure. Create a DSN (using the Data Source applet in the Control Panel),
    select File | Get External Data | Link Tables... from the menu, select "ODBC
    Databases ()" in the "Files of type" selection in the bottom left-hand
    corner of the dialog that appears, select your DSN and go to town!

    Once you've linked the tables, you can switch to a DSN-less connection if
    you want (which means that you won't need to create the same DSN on every
    other desktop). See http://www.accessmvp.com/DJSteele/DSNLessLinks.html for
    one way how.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Domac" <domac.kovacevic@zg.t-com.hr> wrote in message
    news:OXM8hEHiGHA.4368@TK2MSFTNGP03.phx.gbl...
    > Hi,
    >
    > Can I link tables from SQL Server 2000 into Access 97???
    >
    >
    > Thanks!
    > Domac
    >
    >
     
  4. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    Access 97 doesn't understand National Varchar, nVarchar, Unicode fields. No
    problems as long as you only have the kinds of fields that A97 understands.

    (david)



    "Domac" <domac.kovacevic@zg.t-com.hr> wrote in message
    news:OXM8hEHiGHA.4368@TK2MSFTNGP03.phx.gbl...
    > Hi,
    >
    > Can I link tables from SQL Server 2000 into Access 97???
    >
    >
    > Thanks!
    > Domac
    >
    >
     

Share This Page