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,475
    Provided Answers: 11
    Link them by ODBC
    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
    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
  •