Results 1 to 2 of 2

Thread: SQL-Server and Access

  1. #1
    tino Guest

    SQL-Server and Access

    Hi there,

    I have the following problem:

    Is it possible to link a ODBC-datasource, into SQL-Server - 7.0 or 2000, the version doesn't matter.

    Because we do have several databases and we can't move everything to SQL-Server we want to link some tables into SQL-Server. Do you know this is possible and how?

    Anyway, I read that SQL-Server is capable of heterogenous joins - is'nt this feature exactly the heterogenous-join problem?

    Hope you have an answer for me.

  2. #2
    Dale Shaw Guest

    SQL-Server and Access (reply)

    Hi

    Yes, just create a linked server via Enterprise Manager.

    Dale



Posting Permissions

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