Results 1 to 7 of 7
  1. #1
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15

    Link Access Queries To SQL Server Views.


    Is there any way to link access queries to migrated sql server views in order to access them from MS Access? Any help will be really appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    The views are migrated to where? I don't have much experience with SQL Server data but shouldn't you just be able to have Access link to the views and build queries that join the two data sources?

    http://office.microsoft.com/en-us/ac...010200494.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    Thanks for the reply June7.I have read exactly the same link that you have posted above but I don't see anything about using access queries from MS access which are migrated as views in sql server. The thing is, I have queries in Microsoft Access and when I migrated my access database to SQL server those queries are migrated as views in sql server. Now I want to run those views from Microsoft access.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You migrated Access queries to SQL which made them views? Now want to run those views from Access? Are the views action SQL - UPDATE, INSERT, DELETE - and not SELECT?

    This is the only thing I can find that comes close:
    http://accessexperts.net/blog/2011/0...access-part-1/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    Thanks. The queries that I have are all SELECT queries.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Then have you tried linking as suggested by the article?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    I will try doing that way tomorrow at work. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Link the data from SQL server management studio to xls.
    By krkow in forum Import/Export Data
    Replies: 1
    Last Post: 12-12-2011, 08:30 AM
  2. ODBC link from Access to SQL Server changes to read-only
    By Petr Danes in forum Import/Export Data
    Replies: 1
    Last Post: 06-08-2011, 09:46 AM
  3. Replies: 1
    Last Post: 07-17-2010, 08:29 PM
  4. link sql server table to access
    By broken_ice in forum Access
    Replies: 0
    Last Post: 06-28-2010, 12:50 PM
  5. Alter Views/Queries in MDB from C# application.
    By avadhutkhavare in forum Access
    Replies: 0
    Last Post: 11-03-2009, 04:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums