Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005

    Angry Unanswered: Urgent Connection Between Access & Sql 2005

    Dear all
    How I can Connect Btween Tabel In Sql 2005 and Tabel in Access Xp
    to Make Realtion betten Sqltabel & AccessTabel and get the Data
    Please Help Its Urgent
    Sami Al Damiri ...

  2. #2
    Join Date
    May 2008
    Raleigh, NC

    I'm not too sure, but....

    The simplest way is to go into the Access app and link the table. You may need to set up the ODBC connection in your Data Sources (ODBC) under Administrative tools first.

    Hope this helps.

    --If its free, take it for what its worth!

  3. #3
    Join Date
    Jul 2008
    Well in VB.NET you can create a Shema using the 2 tables. Then you set the relationship there as you please. This assumes that you will be using only VB.NET to update the tables.

    You will need to go to the Solutions explorer, click add new item and next select dataset. (Now read up .NET help on how to work with datasets). I can tell you for sure that in the .xsd window you can create a "virtual" database made up of tables from one or more databases, relate the tables and much more...

    keep coding


Posting Permissions

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