Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273

    Unanswered: Querying from Access to SQL Server

    Hi, I am totally new to SQL Server...

    I have set tables up in SQL Server and have my forms in a Access Database, How can I build a query with some reference tables in Access to my main data table in SQL Server,

    Also when I want to create a new record from the form in access what is the best way to write it to my data table in SQL Server, would I be best using an ADO connection?

    Jez

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Link them by ODBC
    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
    Apr 2007
    Location
    Stalybridge, Manchester
    Posts
    273
    Myle, Thanks for the reply but as I stated in my thread I am totally new to SQL Server and still dont understand how I can do anything which I stated in my thread.

    Using ODBC ok but how can I use this?

    Jez

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    One option is to set up the ODBC connection in the ODBC tools (programs | administrative tools | Data Manager (ODBC)

    the other is to set up your connection to the remote database usign the correct ODBC parameters.. have a look in the Access help file on what you need to do to connect via ODBC
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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