Creating a join between Access view and SQL view

  • Am not getting much feedback on this so here is what I think I might do, am currently working in SQL , so I create a connections to my access database and then transfer the data in the view to the SQL DB, then within a Execute SQL Task in a DTS package I could perform my join between the 2 views as I have them now my SQL server... only thing is do I need a way of updating the access view I have now made in SQL...
  • Francis -

    Try creating a linked server.

    If the data is important enough to be used in SQL server, I'd consider getting it moved into SQL for the back end. You could still use Access as a front end, but it scales much better.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply